More than 1 year has passed since last update.

Sql学習メモ-inner join

Posted at 2022-06-09

select e.emp_no, dm.emp_no
from employees as e
         inner join dept_manager as dm;
-- 10003,10002
-- 10002,10002
-- 10001,10002
-- 10003,10003
-- 10002,10003
-- 10001,10003
-- 10002,10003はdept_managerにある。10001,10002,10003はemployeesにある

inner joinの本質はCartesian productです

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up