Not sure what your data looks like or what exactly you are trying to do. But what is wrong with the old standard compare for NULL. Something like ------------------ SELECT first_record.id as first_id, second_record.id as second_id FROM second_record LEFT JOIN first_record ON first_record.id = second_record.id ORDER BY something HAVING first_id = NULL
Here only the second_records will be selected if there is no matching first_record. HTH.. Good luck .. Dan ------------------------- Harpreet Kaur wrote: > Please help, I am stuck and my mind is frozen. > > I want to subtrack one query from the other. I have one query that > brings all the records. The second gets another set of records. > I want to subtract the second query from the first one . How do i do this? > > First query produces like 1000 records. Second has like 800 records i > want to display the other 200 that dont exist in the first query. > > Please help. > > I have this but it is too slow and doesnt work in php but does in mssql. > select distinct a.playlist, > a.material_id, > a.destination_locator, > a.destination, > a.air_time, > a.traffic_duration, > a.comment, > a.title, > a.device_name, > m.media_locator as source_locator, > m.medium_name as source > from cch_dubber_dublist_view11 a left outer join lib_copy_view m > on a.material_id=m.material_id where (A.material_id is not null) and > (A.material_id <>'') > and > NOT EXISTS ( > select null > from > dev_device_view d > inner join > lib_copy_view c > on > d.device_name= c.medium_name > where > c.material_id = a.material_id > AND c.media_locator = a.destination_locator > AND d.device_name = a.device_name > ) > > > > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
