배우기를 멈추는 사람은 20세건 80세건 늙은 것이다.

[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;