mysql q.....

Lets say I have two tables: tbl_cars (vin,make, model, color..._ and
tbl_inspection(vin,emissions, brakes, gas...) and I want to select all cars
that have not yet been inspected. Is there a way to do this with one SQL
statement or do I have to SELECT * FROM cars and run through each one to
check if its been inspected?

Thanks!

Alex

An easy way is to perform an outer join to bring back all rows from tbl_cars and then test for null values in tbl_inspection:
where tbl_inspection.vin is null