공부
[SQL] join?
승가비
2018. 9. 8. 19:12
728x90
[SQL] JOIN?
// JOIN
// INNER JOIN
// LEFT OUTER JOIN
// RIGHT OUTER JOIN
// FULL OUTER JOIN
SELECT * FROM a INNER JOIN b WHERE a.b_id = b.b_id;
SELECT * FROM a LEFT OUTER JOIN b where a.b_id = b.b_id;
SELECT * FROM a RIGHT OUTER JOIN b WHERE a.b_id = b.b_id;
SELECT * FROM a FULL OUTER JOIN b WHERE a.b_id = b.b_id;
728x90