Link to home
Start Free TrialLog in
Avatar of LeoHyppolito
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.


ASKER CERTIFIED SOLUTION
Avatar of krznpsk
krznpsk

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial