multi-table SELECTs

SELECT t1.col1, t2.col1 FROM t1, t2 WHERE t1.col1 = 'someval'; #onscreen demo
SELECT truck.license FROM truck, driver WHERE driver.name = LIKE '%dav%' AND driver.id = truck.driverid;
SELECT truck.id, driver.fname, driver.lname FROM truck, driver WHERE truck.year < 1998 and driver.id = truck.driverid;
SELECT syntax reference