Difference in InnerJoin and simple Query

[ashark]

Hi Group,
What is the difference in the following queries :
use pubs
select t.title, p.pub_name
from publishers as p inner join titles as t
on p.pub_id = t.pub_id
Order by title asc

use pubs
select t.title, p.pub_name
from publishers as p ,titles as t
where p.pub_id = t.pub_id
Order by title asc


Both these queries returnt the same result...

Please help...

 

[swampBoogie]

It is only a syntactical difference, otherwise they are equivalent.

 

[SQLSister]

this is the preferred one as Microsoft may not continue to support the non-Ansi version.

use pubs
select t.title, p.pub_name
from publishers as p inner join titles as t
on p.pub_id = t.pub_id
Order by title asc

 

[swampBoogie]

You are mistaken.

select t.title, p.pub_name
from publishers as p ,titles as t
where p.pub_id = t.pub_id
Order by title asc

is ANSI compliant. Microsoft has newer said anything about not supporting this in the future. What they say is that the SQL Server specific syntax for outer join, i.e.

select t.title, p.pub_name
from publishers as p ,titles as t
where p.pub_id *= t.pub_id
Order by title asc

may not be supported in future releases.