A Two Table Query

Ivains

Hi Everyone,
I'm a little stumped here. I have 2 tables, Table 1 store all my vehicles info and Table 2 stores the vehicle inspection date. If I did not add an inspection date there will be no data in Table 2 for that particular vehicle.

Now here is where I am lost. How can I write a query to bring up all the vehicles that have the date inputted and the ones that don't have information to display NO DATA?

Any help will be appreciated.

Lars_Berg

select * from vehicles 
  left join inspections using(vehicleid)

Change table/column names as apropriate.

Ivains

I tried that and it still didn't work. Maybe I should of show you my sniplet first.

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv, insp
WHERE TO_DAYS(NOW()) - TO_DAYS(insp.qrtrly) >= 90
AND lsv.org = \"$org\"
AND lsv.vid = insp.vid
AND lsv.status != 'DRMO'
ORDER BY nextdue
";

This will display all my vehicles that are overdue their 90-day inspection. I would like it also to display the vehicles that did not have an inspection documented in the insp table. The vid would be common in both tables if the inspection was documented.

Thanks for your help.

Lars_Berg

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv left join insp
on lsv.vid = insp.vid
and TO_DAYS(NOW()) - TO_DAYS(insp.qrtrly) >= 90
where lsv.org = \"$org\"
AND lsv.status != 'DRMO'
ORDER BY nextdue

Ivains

That did the trick. I need to read a little more about JOINS.

Thanks a bunch for your help.