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