LEFT JOIN top 1
Posted on 2007-11-15
Quite an easy one i'm sure but can't get my head around it..
I have a jobs table and an items table (one to many)
I want to select all records from jobs and only record from items (the min date)
My results should only return one row from items based on the MIN(mydate).
The query should still return records from jobs if 1) No rows matched in items and 2) null in mydate column