Inner join distinct

SELECT valueC
FROM C
INNER JOIN
(
    SELECT DISTINCT lookupC
    FROM B INNER JOIN
    (
        SELECT DISTINCT lookupB
        FROM A
    ) 
    A2 ON B.id = A2.lookupB
) 
B2 ON C.id = B2.lookupC

Source: coderoad.ru

Similar codes

5 votes233 views1 answer
Add column table sql default value
SQL
2 votes206 views5 answers
Install postgresql 10 centos 7
SQL
12 votes198 views6 answers
Between in sql
SQL
2 votes192 views1 answer
Sql like variable
SQL
1 vote206 views1 answer
Oracle sequence last_number
SQL
0 vote188 views1 answer
Mysqlimport
SQL
1 vote184 views1 answer
Postgres check blocking
SQL
16 votes208 views5 answers
Select last row in sql
SQL
25 votes196 views6 answers
Change column name mysql
SQL
2 votes196 views6 answers
In operator in sql
SQL