OVERCODE

inner join 예제 본문

프로그래밍/SQL

inner join 예제

오버코드 2018. 6. 5. 13:04

이미지 - www.w3schools.com


INNER JOIN 쿼리


select
	A.user_name,
	B.dept_name,
	C.salary
from 
	member A
		inner join dept B on A.user_id = B.user_id
		inner join salary_info C on A.user_id = C.user_id


비표준 INNER JOIN 쿼리


select
	A.user_name,
	B.dept_name,
	C.salary
from 
	member A, dept B, salary_info C
where A.user_id = B.user_id
and A.user_id = C.user_id



Comments