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 vote236 views1 answer
Mysql changer nom table
SQL
0 vote250 views1 answer
Changing name of column and datatype in sql
SQL
0 vote271 views1 answer
How to get button for every record from mysql
SQL
0 vote225 views1 answer
Object Information
SQL
1 vote222 views1 answer
Oracle user last connected
SQL
0 vote235 views1 answer
Mysql group by range
SQL
0 vote226 views1 answer
Nueva tabla mysql
SQL
0 vote222 views1 answer
Update set with join pl sql
SQL
5 votes247 views2 answers
Sql server port number
SQL
0 vote215 views1 answer
Automate mysql cli query
SQL