Friday, 18 July 2014

Sql Join query


Table name : - atim

Table name :- asignup

1.  select dat,name,email from atim a1 INNER JOIN asignup a2 ON a1.eid=a2.eid





2.  select atim.eid , asignup.name FROM atim FULL OUTER JOIN asignup ON atim.eid=asignup.eid




3.  select dat,name,email from atim a1 LEFT OUTER JOIN asignup a2 ON a1.eid=a2.eid





4.  select dat,name,email from atim a1 RIGHT OUTER JOIN asignup a2 ON a1.eid=a2.eid



5.  select dat,name,email from atim a1 FULL OUTER JOIN asignup a2 ON a1.eid=a2.eid


No comments:

Post a Comment