Left join question

[BETO]

Hi

I have a left join that is only is more like a join .here is what I have

From table A left join table B on a.id=b.id

Where a.date=b.date

);

Run;

I would like everything from table A an where we match from table B

I get back everything we match

[DBailey · Accepted solution]

by including "where a.date=b.date" in the criteria, you have converted from a left join to an inner join.  To make sure it is still a left join, you need to include that as part of the "on" clause...

from

     tableA A

     left join tableB B

          on a.id=b.id and a.date=b.date