CODEWITHSUNDEEP
mysqlinner-join
dazzafact
dazzafact

Reputation: 2878

Select inner JOIN with multiple ids

How can i read about 80 diffrent Fields from another Table with their values? without making the query too long

Table 1 Table 2

I need to combine them. There are about 80 fields.

SELECT * FROM table_1 AS t1
INNER JOIN table_2 AS t2 ON ???

Upvotes: 1

Views: 1728

Answers (1)

nbk
nbk

Reputation: 49410

I fear you have to do something like this

SELECT t1.id
  ,t1.main_id,
  ,t1.web_ids
  ,t2.value as herstellerinterne_baureihebezeichnung
  ,t3.value as modell_start 
  ... 
FROM table_1 AS t1
LEFT JOIN table_2 AS t2 ON t2.id = t1.herstellerinterne_baureihebezeichnung
LEFT JOIN table_2 AS t3 ON t3.id = t1.modell_start

usw.

for all 80 columns. Or you could build a stored procedure, where you would build a select statement by itself (loop through all columns (without the first 3) and execute it, but for that you must post your tables as text.

Upvotes: 2

Related Questions