DATA Step, Macro, Functions and more

SQL join

Super Contributor
Posts: 698

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 and and


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

Super User
Posts: 21,922

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
  • 1 like
  • 2 in conversation