Column ‘ID’ in field list is ambiguous

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

Leave a Reply

Your email address will not be published. Required fields are marked *