asked on SQL JOIN syntax
When doing SQL JOINS is see two different syntax for what seems to be the same thing, one using the JOIN syntax and one not. See examples.
Code 1
SELECT Address.City, Name.NameFirst
from Address, Name
Where Address.AddressId = Name.AddressId
Code 2
SELECT Address.City, Name.NameFirst
from Address
join Name
on name.addressid = address.addressid
Needless to say there are many variations, but the fundamental difference seems to be using the FROM <table1>, <table2>
versus using JOIN <table2>
Even the variations of Left, Right, inner, outer seem easier managed with the Code 1 concept.
To me same Code 1 seems lots simpler.
Code 1
SELECT Address.City, Name.NameFirst
from Address, Name
Where Address.AddressId = Name.AddressId
Code 2
SELECT Address.City, Name.NameFirst
from Address
join Name
on name.addressid = address.addressid
Needless to say there are many variations, but the fundamental difference seems to be using the FROM <table1>, <table2>
versus using JOIN <table2>
Even the variations of Left, Right, inner, outer seem easier managed with the Code 1 concept.
To me same Code 1 seems lots simpler.
Microsoft SQL Server
Last Comment
Pavel Celba
Was there a question in there somewhere?
ASKER
The question is, when and why would you need to use the JOIN syntax as both styles seem the same. And is it simply a matter of style? Just trying to learn best methods.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.