sql select,get most recent entry for each car

Programmer Question

My database (MySql) has 2 tables

Table 1 - contains a record for each car

cars= id(int), reg(int), type(int)

Table 2 - contains jobs for each car

jobs = id(int),date(date)

I need a SELECT command which will get me the most recent job for all id's

Thanks in advance.

Find the answer here