티스토리 뷰

공부

[SQL] join?

seunggabi 승가비 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

'공부' 카테고리의 다른 글

[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
댓글
댓글쓰기 폼