[Q] Merging two queries? - Mailing list pgsql-sql

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