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
Set open file limit mac catalina mysql
SQL
2 votes194 views2 answers
Install sqlalchemy
SQL
2 votes189 views2 answers
Sql lag
SQL
2 votes308 views1 answer
Mysql create user with remote access
SQL
5 votes225 views1 answer
Mysql created at yesterdau
SQL
0 vote198 views1 answer
Sql delimiter to columns
SQL
0 vote201 views1 answer
Connect postgresql using a connection string
SQL
1 vote178 views1 answer
Sql delete all values in a column
SQL
65 votes543 views6 answers
Sql add column to table
SQL
0 vote173 views1 answer
Oracle index hint multiple tables example
SQL