SQL join

[SASPhile]

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

[Reeza]

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