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