LeoHyppolito
asked on
Join question
Hello,
Is there any difference between these two select commands?
(from the sample 'Pubs' database in MS SQL Server 2000)
-------------------------- ---------- ---------- ---------- --
select T.title, P.pub_name
from titles T
join publishers P on (T.pub_id = P.pub_id);
-------------------------- ---------- ---------- ---------- ---
select T.title, P.pub_name
from titles T, publishers P
where (T.pub_id = P.pub_id);
-------------------------- ---------- ---------- ---------- --
I know that they return the same records.
But I learned in my Oracle classes (in college) to do joins like the second select.
And now I am reading a MS SQL Server book that teaches joins like in the first select.
So.....
Is there a "better" way, or it's just a matter of personal taste?
Thanks in advance.
Is there any difference between these two select commands?
(from the sample 'Pubs' database in MS SQL Server 2000)
--------------------------
select T.title, P.pub_name
from titles T
join publishers P on (T.pub_id = P.pub_id);
--------------------------
select T.title, P.pub_name
from titles T, publishers P
where (T.pub_id = P.pub_id);
--------------------------
I know that they return the same records.
But I learned in my Oracle classes (in college) to do joins like the second select.
And now I am reading a MS SQL Server book that teaches joins like in the first select.
So.....
Is there a "better" way, or it's just a matter of personal taste?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.