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

1 vote241 views1 answer
Oracle truncate partition
SQL
3 votes235 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote245 views1 answer
Reset postgres table index to next max value
SQL
0 vote255 views1 answer
Java sql timestamp now
SQL
23 votes244 views3 answers
Sql where contains part of string
SQL
0 vote231 views1 answer
Count number of entires by months sql
SQL
1 vote212 views4 answers
Fatal database postgres does not exist
SQL
0 vote232 views1 answer
Copy Table from SQL to CSV
SQL
0 vote228 views1 answer
Two inner joins sql
SQL
2 votes239 views2 answers
Sqlalchemy filter or
SQL