Can you help me with the below syntax error
Column reference "id" is ambiguous is the error which I am getting.
insert into table1 (id, name, type, version) select id, '' as name, 'exteal' as type, -1 as version from table2 left outer join table1 on table2.id = table1.id where table1.id is null group by table2.id, table1.name
order by table2.id, table1.name