468,507 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

Difference between Full Join and Inner Join in SQl Server 2005

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.
Apr 4 '07 #1
3 22367
MMcCarthy
14,534 Expert Mod 8TB
This question is being moved to the SQL Server forum.

ADMIN
Apr 4 '07 #2
iburyak
1,017 Expert 512MB
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.
Apr 4 '07 #3
thank u, the answer given by u helps me
Jul 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by kieran | last post: by
2 posts views Thread by corassaumzinho | last post: by
3 posts views Thread by janko.klemensek | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.