It looks like the tables you’re joining have columns with the same name, is that correct? If so, you’ll want to use aliasing to give the ambiguous columns distinct names. Here is an example:
table names: table, table2
column names that are the same in each table: item, item1
select
t1.item as i, t1.item1 as i1, t2.item as i2, t2.item1 as i3
from
table as t1
join
table2 as t2 on t1.id = t2.idreturns table with four columns: i, i1, i2, i3