SQL Error [1052] [23000]: Column 'id' in field list is ambiguous code example
Example: column in field list is ambiguous
SELECT n.id, s.id, n.name, s.section
FROM tbl_names n
JOIN tbl_section s ON s.id = n.id
SELECT n.id, s.id, n.name, s.section
FROM tbl_names n
JOIN tbl_section s ON s.id = n.id