What is joins & its type
with example
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Biswa Pujarini MohapatraPosted Feb 6, 2014, 3:00 AM
data : Hari and Ram belongs to HR, Sam belongs to IT
then you must have 2 tables for normalization
Employee table
-----------
EMPID Name DeptID
1 Hari 1
2 Sam 2
3 Ram 1
Department table
---------------
Deptid DeptName
1 HR
2 IT
Inner join : This join returns rows when there is at least one match in both the tables.
Select * from employee e Inner join Department d on e.Deptid = d.deptid
Outer join : LEft outer join, Right outer join and cross join
for more details check this
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/