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

-1 vote178 views2 answers
Get day in sql
SQL
5 votes206 views1 answer
Oracle nls parameters
SQL
0 vote182 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote184 views1 answer
Sysdate in sql
SQL
1 vote196 views1 answer
Mysql not supported auth mode
SQL
0 vote188 views1 answer
Narural join
SQL
11 votes174 views1 answer
Oracle view ddl
SQL
2 votes220 views1 answer
Oracle current date without time
SQL
0 vote225 views1 answer
Concat column value of same user in mysql
SQL
1 vote172 views1 answer
Mysql server does not start mac
SQL