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

13 votes155 views3 answers
List all the tables in sql
SQL
1 vote143 views1 answer
Spark sql convert string to date
SQL
0 vote126 views1 answer
Sql replace id with name from another table
SQL
1 vote132 views1 answer
Quit mysql
SQL
4 votes135 views1 answer
W3schools create table
SQL
5 votes119 views1 answer
Alter table add comment oracle
SQL
0 vote129 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote121 views1 answer
Mysql history command
SQL
1 vote132 views1 answer
How to use db.execute
SQL
0 vote125 views1 answer
Stored procedures example
SQL