it is just because you have 2 tables with both a field ID, so the database engine will get confused about the table name from which the the data to be fixed

Use table1.id, or table2.id, based on the table you want the data