SQL INNER JOIN

[gary5utton]

Hey everyone, quick question... in an SQL INNER JOIN query, is ON the same as WHERE... is there some similarity? NOt sure when to use them in a query.

Thanks

gary

 

[sbendbuckeye]

Older style SQL used Where clause joins, New style SQL uses From clause joins. At least in Access, Where clause joins will sometimes result in Read Only recordsets.

Assume you have FName and LName tables with an LNameID as a key. The following are equivalent as far as the data they will return.

Using From clause join
Select FName.f1, LName.f1
From FName Inner Join LName
On FName.LNameID = LName.LNameID
Order By LName.f1, FName.f1

Using Where clause join
Select FName.f1, LName.f1
From FName, LName
Where FName.LNameID = LName.LNameID
Order By LName.f1, FName.f1

Where clauses can still be used to further filter your data
Select FName.f1, LName.f1
From FName Inner Join LName
On FName.LNameID = LName.LNameID
Where LName.f1 = "Smith"
Order By LName.f1, FName.f1

Good Luck!

 

[gary5utton]

This is exactly what I was looking for!!!

Thanks,


gary