JOINS
INNER JOIN : Gives Commoon Value in both the table
OUTER JOIN
LEFT-Takes common + uncommon vlaue from left table
Right- takes Common + Uncommon value from Right Table
FULL OUTER JOIN- Gives full left right
SELF JOIN:
http://databases.about.com/od/sql/a/selfjoins.htm
No comments:
Post a Comment