Join Queries
Inner JoinTheta Join SELECT * FROM student INNER JOIN class ON student.class_id = class.class_id; which is equivalent to SELECT * FROM student, class WHERE student.class_id = class.class_id; Equi Join SELECT * FROM student INNER JOIN class USING (class_id); Natural Join SELECT * FROM student NATURAL JOIN class; Cross JoinAn explicit cross join is performed using SELECT * FROM student CROSS JOIN grade; while an implicit cross join can be performed using SELECT * FROM student, grade; Outer JoinsLeft Outer Join SELECT * FROM assignment LEFT OUTER JOIN grade ON assignment.asgm_id = grade.asgm_id; Right Outer Join SELECT * FROM assignment RIGHT OUTER JOIN grade ON assignment.asgm_id = grade.asgm_id; Full Outer Join SELECT * FROM assignment FULL OUTER JOIN grade ON assignment.asgm_id = grade.asgm_id;
|