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

10 votes267 views5 answers
Mysql create user
SQL
0 vote220 views1 answer
Get last run query sql server
SQL
2 votes288 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
1 vote241 views1 answer
Minus vs intersect in sql
SQL
3 votes282 views2 answers
Sqlite show table structure
SQL
0 vote279 views1 answer
Exit psql
SQL
0 vote240 views1 answer
Suse start MySQL
SQL
0 vote270 views1 answer
Mysql type for large numbers with many decimal
SQL
1 vote264 views1 answer
Deleting database in sql
SQL
0 vote271 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL