Can I execute this query in a single JOIN statement?
select * from hist where date_h = '20041027' and tel not in (select distinct tel from hist where date_h < '20041027')
I know I could do it using a temporary table, but I wonder if there's a way to do it directly. Thanks! Hector
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
