471,092 Members | 1,025 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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 22435
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.