BOXI R3
SQL Server 2005
I have a join in my universe that just wont go to a left outer join, I’ve tried defining the join many different ways but I just cannot force it to be a left outer, some other joins in my universe however do work as left outer joins, I have ANSI 92 set to Yes.
I’ve been through numerous posts and there doesn’t appear to be a concise solution can anyone help me please?
The tables I have are
A 1158 rows
B 26223 rows
C 4857 rows
D 280570 rows
I can get left joins on my joins between B-C, C-D but never on A-B.
Interestingly if I change the join on A-B it flips the joins on B-C and C-D to right outers also??
James Head 
(BOB member since 2005-02-14)