SQL: Quiz 05 -- JOIN

Table1

Table2

Table3

.

Table: STUD

Table: CLUB

SQL(1)： 　SELECT * FROM STUDENT;　

Result: 　0

　 　 

INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN


SELECT * FROM stud
	LEFT JOIN club ON stud.act=club.act
UNION
SELECT * FROM stud
	RIGHT JOIN club ON stud.act=club.act;