[PHP-DB] Re: subtracting one query from the other From: Dan Koken (dkokenge <email protected>)
Date: 06/27/02

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