a and b r not tables but views. i am using multiple views .
The sql for the views are as follows:
CREATE view cch_dubber_dublist_view_a1 as 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
>From: [EMAIL PROTECTED] (Dan Kokenge)
>To: [EMAIL PROTECTED] ("Harpreet Kaur")
>Subject: Re: [PHP-DB] Re: subtracting one query from the other
>Date: Tue, 02 Jul 2002 00:33:21 -0400
>
>
>Hi Harpreet
>
> >SELECT distinct a.playlist,a.material_id,a.destinat
