Damn...
So this is simple
I have one table and I want to return all records from one table where a value - zero.
I then want to join it to another table but whether there is any data in the other table or not I still want the query to return all records from the first table with just null values if there is no data in the second table...
so thats a left outer join (or left join)
but apparently not
why I am so dumb and what am I missing?
So this is simple
I have one table and I want to return all records from one table where a value - zero.
I then want to join it to another table but whether there is any data in the other table or not I still want the query to return all records from the first table with just null values if there is no data in the second table...
so thats a left outer join (or left join)
but apparently not
why I am so dumb and what am I missing?
Comment