Question: SQL - Joins 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
-
SQL - Joins
-
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help