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 votes136 views3 answers
Current month mysql query
SQL
0 vote165 views1 answer
Stop psql server windows
SQL
2 votes131 views1 answer
Check isolation level in mysql
SQL
0 vote167 views1 answer
Sql get latest of 2 datetimes
SQL
1 vote157 views3 answers
Postgresql crete view
SQL
1 vote128 views1 answer
Postgres check for foreign key
SQL
2 votes158 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote132 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote153 views1 answer
Uncheck constraints and delete from table
SQL
2 votes131 views1 answer
Sql as
SQL