LoginSignup
0
0

More than 1 year has passed since last update.

Sql学習メモ-inner join

Posted at
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です

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0