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 vote267 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote323 views1 answer
What is default mysql database password in linux
SQL
13 votes308 views3 answers
Sql online code
SQL
0 vote302 views1 answer
Sql right characters
SQL
0 vote315 views2 answers
Python mysql create table if not exists
SQL
5 votes379 views1 answer
Oracle drop index if exists
SQL
0 vote320 views1 answer
Oracle free up space in tablespace
SQL
0 vote341 views1 answer
How to get nth number in sql
SQL
0 vote318 views1 answer
Sum value by month sql
SQL
0 vote339 views1 answer
Sql put two columns into one
SQL