9 messages in com.mysql.lists.win32Help in Subquerys...
FromSent OnAttachments
Jan Theodore Galkowski14 Dec 2004 10:16 
Daniel Bronzeri Barbosa14 Dec 2004 10:24 
Daniel Bronzeri Barbosa14 Dec 2004 10:40 
Daniel Bronzeri Barbosa14 Dec 2004 10:46 
Troy Whistman14 Dec 2004 11:14 
Daniel Bronzeri Barbosa14 Dec 2004 11:30 
Jan Theodore Galkowski14 Dec 2004 20:57 
Daniel Bronzeri Barbosa15 Dec 2004 08:38 
Randy Clamons15 Dec 2004 12:30 
Subject:Help in Subquerys...
From:Daniel Bronzeri Barbosa (dan@arccorp.com.br)
Date:12/14/2004 10:24:33 AM
List:com.mysql.lists.win32

People,

How can I run this query in MySQL 4.0???

SELECT * FROM `tbl_hlt_phonecall_historicaldata` WHERE int_key in ( select max(int_key) from tbl_hlt_phonecall_historicaldata group by int_phonecall_key )

Tanks for your help.

Daniel