SQLアンチパターン18章

SQLアンチパターン18章.sql

create table fuga(id int, name varchar(255));
create table piyo(id int, name varchar(255));
insert into fuga values(1, "fugafuga");
insert into piyo values(1, "fugafuga");
select * from fuga f inner join piyo p on f.id = p.id;
/* 
+------+----------+------+----------+
| id   | name     | id   | name     |
+------+----------+------+----------+
|    1 | fugafuga |    1 | fugafuga |
+------+----------+------+----------+
*/