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 vote373 views1 answer
Split string by comma in sql server
SQL
0 vote355 views1 answer
How to to get time in sql
SQL
0 vote348 views1 answer
Mysql sum with group by
SQL
3 votes347 views2 answers
How to modify rows in SQL Server
SQL
0 vote330 views1 answer
Json not contains mysql
SQL
0 vote381 views1 answer
Table structure in sql
SQL
0 vote330 views1 answer
Oracle search in date columns
SQL
0 vote347 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote322 views1 answer
Hangfire clean script
SQL
1 vote328 views1 answer
Mysql server does not start mac
SQL