I have two tables:
I am retrieving all car measurements and get a result set that currently look like this:
When there are no car measurements for BMW335 on 2013-06-21 (no row in the db), I’d still like to have an empty row returned so that the result would like this:
How I can get this result back from my MSSQL 2008 database? Or should I be looking at doing this at PHP/Yii level?
The current query look like this: