[SQL] join?

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