/SQL/Join creating duplicate columns sqllite

Join creating duplicate columns sqllite

select 
  t1.cust_id, t1.col1, t1.col2, 
  t2.col1_table2, t2.col2_table2, 
  t3.col1_table3, t3.col2_table3
from
 table1 t1 
inner join
 table2 t2 on t1.cust_id = t2.cust_id
join table3 t3 on t1.cust_id = t3.cust_id

Source: stackoverflow.com

Similar codes

4 votes128 views1 answer
Create db table
SQL
0 vote135 views2 answers
Postgres default user
SQL
0 vote138 views1 answer
Default order by in mysql
SQL
0 vote138 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote143 views1 answer
Mysql select if empty result
SQL
12 votes151 views4 answers
How to check mysql version ubuntu
SQL
0 vote161 views1 answer
Ubuntu connect to mssql database
SQL
0 vote181 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
8 votes166 views1 answer
Mysql dump restore
SQL
8 votes134 views2 answers
Mysql get first x characters
SQL