inner join 예제

이미지 - 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