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.destination_locator,
a.destination,a.air_time,a.traffic_duration