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 vote208 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
4 votes195 views2 answers
Mysql show indexes on table
SQL
0 vote194 views1 answer
Alter table engine mysql
SQL
3 votes272 views1 answer
Delete all content in table mysql
SQL
0 vote228 views1 answer
Sql server delete records with specific date
SQL
2 votes215 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote220 views1 answer
Mysql get only the field names in a table
SQL
6 votes265 views2 answers
Mysql check auto increment value
SQL
0 vote182 views1 answer
List MySQL Table and Index Size
SQL
3 votes254 views2 answers
Brew restart mysql
SQL