DATA Step, Macro, Functions and more

SQL join

Reply
Super Contributor
Posts: 673

SQL join

when performing a inner join a where or On will yeild same results?

from  INDIV a , acct b ,char c,tads d

      where a.id=b.id and

      a.id=d.id and

    a.id1=d.id1

Idea is to get columns where there are common id's

Super User
Posts: 19,789

Re: SQL join

A database professional’s best friend - The SAS Training Post

The above may be very helpful.

You can always get to where your going by more than one path, but some are faster than others Smiley Happy

Ask a Question
Discussion stats
  • 1 reply
  • 152 views
  • 1 like
  • 2 in conversation