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

2 votes154 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote129 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
4 votes149 views2 answers
Installing sql on ubuntu
SQL
3 votes165 views1 answer
How to add unique constraint in mysql table
SQL
0 vote129 views1 answer
Sql select most frequent value in group
SQL
1 vote149 views1 answer
Drop primary key oracle
SQL
0 vote132 views1 answer
Oracle current timestamp
SQL
0 vote124 views1 answer
What is initial catalog in sql connection string
SQL
0 vote153 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote129 views1 answer
Sql constarint
SQL