WHERE as part of JOIN not after

[thestappa]

Hello,



I am stuck on a JOIN problem that I can't see to work around.

I have a left join with criteria on the joining field. The problem is when the tables join on that field, some of the 1st tables rows are being removed by the where clause. I think what's happening is the join is putting the tables together, then removing rows based off of the criteria.

What I would like is the where clause to remove rows from table 2 first, then do the join with table 1 so ALL rows from table one remain.

[TheShabz]

put up your SQL and let's see if we can work something out for you.