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 votes331 views2 answers
Show tables in schema oracle
SQL
2 votes315 views1 answer
Oracle cpu per session
SQL
0 vote326 views1 answer
Alter table fulltext
SQL
0 vote341 views1 answer
Mariadb cast null to 0
SQL
0 vote391 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote343 views2 answers
Psql commande \gset
SQL
0 vote351 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote325 views1 answer
Mysql query single row
SQL
0 vote321 views1 answer
Codeigniter dbforge add index
SQL
0 vote328 views1 answer
Check sql database table lock
SQL