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

4 votes161 views1 answer
Force drop all tables postgres
SQL
0 vote160 views1 answer
Sql server inner join convert collation
SQL
0 vote163 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote187 views2 answers
Sql queries practice
SQL
0 vote186 views1 answer
Mysql sleep connections
SQL
1 vote182 views1 answer
Mysql select and count left join
SQL
-1 vote167 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote161 views1 answer
Sql server whoami
SQL
1 vote175 views1 answer
Mysql get latest duplicate rows
SQL
0 vote158 views1 answer
Sql comparison operators
SQL