Appendix. CROSS JOIN

dpwl·2024년 5월 19일

Data Analysis with SQL

목록 보기
91/120

1. CROSS JOIN

CARTESIAN JOIN

SELECT Columns
FROM TableR R
CROSS JOIN TableL L
# Join Key 필요 X

1.1 USING을 활용한 JOIN

SELECT cols
FROM table1 AS a
JOIN table2 AS b
USING (col)
profile
거북선통통통통

0개의 댓글