performance

Last Post 18 Jun 2008 05:55 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
18 Jun 2008 05:55 AM
is there a significant difference in perf using inner join vs liosting tables

select c.*
from car c, cardetail cd
where c.carid = cd.carid
and c.carid is not null

GO

select c.*
from car c inner join cardetail cd on c.carid = cd.carid
where c.carid is not null

thanks


Acceptable Use Policy
---