Re: joins

From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
Date: 26 Aug 2006 00:46:31 -0700

kalaivanan wrote:

hi dis is kalaivanan,
which one of inner join or left join is efficient and in what way.

Inner joins and outer joins achieve different results so in general it
won't make sense to compare them on performance.

In cases where an inner and outer join are guaranteed to give the same
result I suggest you test it out for yourself. Performance is too
heavily dependent on other factors for there to a be a single, simple
answer.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

.

Follow-Ups:
- Re: joins
  - From: Erland Sommarskog

References:
- joins
  - From: kalaivanan

Prev by Date: joins
Next by Date: Moving from mssql to postgres, advice needed
Previous by thread: joins
Next by thread: Re: joins
Index(es):
- Date
- Thread

Relevant Pages

Re: Problem With Nested Joins
... FROM tblApartments AS A ... INNER JOIN tblResidents AS R ... > The problem is not so much an issue if a resident has no numbers listed (I> think this is what OUTER JOINS really address), but if they only have> numbers other than 'Work' listed. ...
(microsoft.public.access.formscoding)
Re: Problem With Nested Joins
... FROM tblApartments AS A ... INNER JOIN tblResidents AS R ... > The problem is not so much an issue if a resident has no numbers listed (I> think this is what OUTER JOINS really address), but if they only have> numbers other than 'Work' listed. ...
(microsoft.public.access.queries)
Re: Query not Returning Results
... Changing all INNER Joins to OUTER joins but when run a Synax Error was ... When i come to running the query i simply get no results ... FROM vehicle INNER JOIN (supplier INNER JOIN (salesman INNER JOIN ...
(microsoft.public.access.queries)
Re: View Problem
... > If you want rows even when not all columns referring other tables are not ... > LEFT OUTER JOINs. ... > SQL Server MVP ... >> INNER JOIN ...
(microsoft.public.sqlserver.server)
Re: Problem With Nested Joins
... RIGHT JOIN (tblApartments AS A ... INNER JOIN tblResidents AS R ... > INNER JOINs cannot be nested inside OUTER JOINs." ...
(microsoft.public.access.queries)