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 vote267 views1 answer
Show per page table in xampp
SQL
10 votes257 views3 answers
Insert into auto increment mysql
SQL
0 vote289 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote264 views1 answer
Pl sql search in all packages
SQL
0 vote268 views1 answer
Get create sql of hibernqte entity
SQL
0 vote260 views1 answer
Rabbitmq service not starting
SQL
1 vote290 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote212 views1 answer
Sqlalchemy existing database
SQL
3 votes248 views1 answer
Oracle function
SQL
0 vote266 views2 answers
Sql update multiple tables
SQL