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

5 votes166 views1 answer
Oracle create table comment
SQL
-1 vote158 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote141 views1 answer
Sql string length postgresql
SQL
5 votes140 views2 answers
Oracle timestamp to date
SQL
0 vote166 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote159 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote134 views1 answer
Sql query to select records entered in last 24 hours
SQL
1 vote156 views2 answers
Mysql between
SQL
2 votes161 views3 answers
Sql delete duplicate
SQL
0 vote167 views2 answers
Dbms transaction tutorialspoint
SQL