Joint two table with subrow

[alberttra]

I' struggle with joining two following table:
Table1

Table 2

The row company of table 1 contains two industry_id, which I want to joint with the second table. The result should be like this:

`

ADIDAS AG | 194677F8-7774-4685-896D-9FB45E248245 | Sshwaz

| 4418BACC-BF07-452C-B3A7-BACBAD469FFD | Retail

DEUTSCHE LUFTHANSA AG

`

Is there anyway to get that result?

[to4kawa]

please provide both queries.