I need to extract datas from a first table, contening the codes, and then encode said codes with a second table.

The first table looks like:

TABLE1

The second table looks like

TABLE2

The query I would need to extract is the following

If possible I would want to extract only 1 record selecting by the ID

CodePudding user response：

We can try joining the first table to the second one, thrice:

SELECT
    t1.ID,
    t2a.Descritption AS "Payment type",
    t2b.Description AS Country,
    t2c.Description AS "Business Sector"
FROM TABLE1 t1
LEFT JOIN TABLE2 t2a
    ON t2a.ID = t1."Payment type" AND t2a."Type econde" = 'Pay'
LEFT JOIN TABLE2 t2b
    ON t2b.ID = t1.Country AND t2b."Type econde" = 'Country'
LEFT JOIN TABLE2 t2c
    ON t2c.ID = t1."Business Sector" AND t2c."Type econde" = 'Business';