Difference between Full Join and Inner Join in SQl Server 2005

Smita Kashyap

What is the main difference between Full Join and Inner Join in SQl Server 2005 ?
As inner join retrive all records that match certain condition, similiary in full join will rreturn all records only where they match.
Also sugest me which one is optimal in Inner Join and Where clause.

msquared

This question is being moved to the SQL Server forum.

ADMIN

iburyak

Inner Join returns matching records only

A full outer join returns all rows in both the left and right tables

Hope it is clear enough.

deepakyadav007

thank u, the answer given by u helps me

Difference between Full Join and Inner Join in SQl Server 2005

re: Difference between Full Join and Inner Join in SQl Server 2005

re: Difference between Full Join and Inner Join in SQl Server 2005

re: Difference between Full Join and Inner Join in SQl Server 2005

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about