티스토리 뷰
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
'공부' 카테고리의 다른 글
[Greedy] jewelryThief - priority_queue(heap) (0) | 2018.09.08 |
---|---|
[SQL] groupBy & having? (0) | 2018.09.08 |
[SQL] join? (0) | 2018.09.08 |
[SQL] where & orderBy & limit (0) | 2018.09.08 |
[Math] changeProposition? (0) | 2018.09.08 |
[Graph] Floyd Warshall? (0) | 2018.09.08 |
댓글