Oracle Left Outer Join

[MickG]

Hi, In this case I only have one value to join on...'Car'.
And I'm looking for a list of cars that do no have a corresponding attribute value '4WD' in the 'Drive' Column of the f_carattribute table. I'm Looking for cars that do not have 4WD option at a site. Not exists...
This is what I have now...

SELECT distinct C.Car, CA.Car
FROM shop.f_car C, shop.f_carattribute CA
WHERE C.Site= 'DNV' AND C.Car = CA.Car(+);

If anyone could advise that would be great!
Thanks Mick

[Krzemo]

I'm failed to understand what U are trying to do.
Please provide more info on subject (sample data,reuired output etc).

Best regards,
Krzemo.

PS: In Oracle 9i and above , Oracle strongly discourages using (+) for joins. Better use new "JOIN" syntax which is ANSI compilant.