Received: from mail.saw.net (brook.saw.net [205.162.201.3]) by hub.org (8.9.3/8.9.3) with SMTP id RAA55884 for ; Sat, 18 Dec 1999 17:12:38 -0500 (EST) (envelope-from angelko@saw.net) Received: (qmail 1649 invoked by uid 1142); 18 Dec 1999 23:00:18 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 18 Dec 1999 23:00:18 -0000 Date: Sat, 18 Dec 1999 15:00:18 -0800 (PST) From: To: pgsql-sql@postgresql.org Subject: [Q] Merging two queries? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, I'm working on a query that confuses me. This is a database of vehicles, and dealers. four tables are involved. Dealership, UsedCar, Members, Ads Dealership contains the information about various car dealerships. UsedCar contains the information about the cars those dealerships sell. Members is similar to Dealership, except it is for car owners who are sellilng their own vehicle. Each owner from Members has one or more entries in Ads table. Ads table contains the information about the used cars that members want to sell. Here is a sample query involving Dealership and UsedCar SELECT DISTINCT UsedCar.Make, UsedCar.Model FROM Dealership, UsedCar WHERE Dealership.DealerID = UsedCar.DealerID AND Dealership.States Like '%Oregon%' And the sample output is: Pontiac |Grand prix se sedan 4d Pontiac |Sunfire se sedan 4d Saturn |Sc1 coupe 2d Saturn |Sc2 coupe 2d Here is another query involving Members and Ads SELECT DISTINCT Ads.Make, Ads.Model FROM Members, Ads WHERE Members.Member_ID = Ads.Member_ID AND Members.Addr_State = 'OR' And the sample output is: Pontiac |Sunfire se sedan 2d Saturn |Sc2 coupe 4d I would like to create a single query that will generate output like: Pontiac |Grand prix se sedan 4d Pontiac |Sunfire se sedan 2d Pontiac |Sunfire se sedan 4d Saturn |Sc1 coupe 2d Saturn |Sc2 coupe 2d Saturn |Sc2 coupe 4d Anyone has any suggestions? Thanks, -angelko