Hi,
Move the conditions b.tag = 1 and b.day = 11323
into the ON clause of the outer join.
In your present query, the result of the outer join gets filtered
with the two conditions, and those are not true for the records in T1
that have no matching rows in b.
Jan
Roger Karnouk wrote:
>
> I
I am trying to do a left join query to retrieve all the rows in Table T1
and a value from server01_history.
There are 100 rows in T1 and I expect some NULL values for b.total
returned from server01_history.
Does anyone have any Idea why I only get back 93 rows with no nulls
when