sqlite duplicate column header on select -

i noticed when select :

select * table1 join table2 

if both tables happened have column same name, sqlite shows 2 columns name. example if both tables have id column, in result 2 identical column header. behaviour causing problems when working jdbc, cannot value of column. there generic way overcome this. example make sqlite give prefix these columns, or refuse execute query.