mysql> select id,family_name,held_date_time from students inner join interviews on interview_id = interviews.id; ERROR 1052 (23000): Column 'id' in field list is ambiguous ↑ idはどちらにも含まれるカラムのため特定不能 mysql> select students.id,family_name,held_date_time from students inner join interviews on interview_id = interviews.id; +----+-------------+---------------------+ | id | family_name | held_date_time | +----+-------------+---------------------+ | 6 | ?? | 2007-08-02 20:00:00 | | 11 | ?? | 2007-09-18 01:00:00 | | 15 | u | 2007-08-27 20:00:00 | +----+-------------+---------------------+