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 vote180 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote200 views1 answer
Get only one row in mysql
SQL
0 vote207 views1 answer
Stop psql server windows
SQL
0 vote234 views1 answer
Alter database name script
SQL
2 votes160 views1 answer
When matched in sql server
SQL
0 vote183 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote194 views1 answer
Sql get highest date from 3 tabels
SQL
2 votes191 views2 answers
Mysql show table column comments sql
SQL
0 vote166 views1 answer
Tsql delete all rows
SQL
3 votes173 views1 answer
Sql case update
SQL