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 votes245 views2 answers
Set value to null sql
SQL
0 vote196 views1 answer
How to drop columns with constraint from a table in sql script
SQL
1 vote214 views1 answer
Query for all indexes in table postgres
SQL
0 vote210 views1 answer
How to close external sql connection in laravel
SQL
1 vote211 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote216 views2 answers
Uninstall postgresql mac
SQL
0 vote203 views2 answers
Update information in a mysql column
SQL
1 vote198 views1 answer
Mysql return if it contains
SQL
0 vote220 views1 answer
Oracle running queries
SQL
0 vote203 views1 answer
Sql add calculated column
SQL