happy55 (12/27/2013)
Yes I had a where clause for table B.I removed it as per your suggestions and it works:-)Thanks for your help
I've seen it a lot of times and it surprised me the first time I had this issue. The conditions on table b transformed your outer join into an inner join.
Here's a nice article on it: Fun with Outer Joins[/url]
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2