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

0 vote196 views1 answer
Top frequency in sql server
SQL
7 votes325 views2 answers
Mysql default value
SQL
0 vote198 views1 answer
Postgresql create table many-to-many
SQL
1 vote188 views1 answer
Use of now() in mysql
SQL
0 vote206 views1 answer
Drop CHECK constraint sql
SQL
0 vote192 views2 answers
Cambiar nombre tabla mysql
SQL
2 votes243 views1 answer
Remove foreign key constraints in postgres
SQL
15 votes217 views4 answers
Pl sql
SQL
0 vote217 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote187 views1 answer
Error code 1241 mysql
SQL