JOIN๋ฌธ - ๋ฌธ์ 2
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465--๋ฌธ์ 1) ์ฌ์๋ค์ ์ด๋ฆ, ๋ถ์๋ฒํธ, ๋ถ์๋ช
์ ์ถ๋ ฅํ๋ผSELECT a.first_name, b.department_id, b.department_nameFROM employees a, departments bWHERE a.department_id = b.department_id; --๋ฌธ์ 2) 30๋ฒ ๋ถ์์ ์ฌ์๋ค์ ์ด๋ฆ,์ง์
,๋ถ์๋ช
์ ์ถ๋ ฅํ๋ผSELECT a.first_name, a.job_id, b.department_id, b.department_nameFROM employees a, d..
2021. 2. 10.