Left Outer Join on multiple conditions with greater than or less than

[adam0101]

I have a query that looks like this:

SELECT  tbl1.id,
        tbl2.id
FROM    tbl1,
        tbl2
WHERE   tbl1.ActionDate > tbl2.StartDate
AND     (tbl1.ActionDate < tbl2.EndDate
        OR
        tbl2.EndDate IS NULL)

I'd like to turn it into a LEFT OUTER JOIN where I get all the items from tbl1 and only the items from tbl2 where the conditions in the WHERE clause are true. How would I do this?

 

[tlbroadbent]

See my reply in the SQL Server forum - thread183-319323. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.