select * from table1 left join table2 on table1.id=table2.id Error: duplicate column name, id Is this an error or a feature? \Oliver