IV. SQL - Joins Student Course ROLL NO NAME Age COURSE ID ROLL NO 1 HARSH 18 1 1 2 PRATIK 19 2 2 3 RIYANKA 20 2 3 4 DEEP 18 3 4 5 SAPTARHI 19 1 5 6 DHANRAJ 20 4 7 ROHIT 18 5 10 8 NIRAJ 19 4 11 SELECT * FROM STUDENT INNER JOIN COURSE ON Student.ROLL_NO= Course.ROLL_NO; Inner Join SELECT * FROM STUDENT LEFT JOIN COURSE ON Student.ROLL_NO= Course.ROLL_NO; Left Outer Join SELECT * FROM STUDENT RIGHT JOIN COURSE ON Student.ROLL_NO= Course.ROLL_NO; Right Outer Join