## Left join question

Solved
Regular Contributor
Posts: 240

# Left join question

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

Accepted Solutions
Solution
‎12-03-2014 05:29 PM
Super Contributor
Posts: 578

## Re: Left join question

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

All Replies
Solution
‎12-03-2014 05:29 PM
Super Contributor
Posts: 578

## Re: Left join question

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

🔒 This topic is solved and locked.