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 vote150 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote137 views1 answer
Knex last insert id mysql
SQL
14 votes156 views3 answers
SQL trim
SQL
3 votes151 views1 answer
Create a table with an id in mysql
SQL
1 vote169 views1 answer
Psql connect to another database
SQL
5 votes152 views1 answer
How to check nls format in oracle
SQL
3 votes159 views5 answers
Sql select
SQL
1 vote141 views4 answers
Sequelize migration default value
SQL
0 vote144 views1 answer
Sqlite closes value
SQL
0 vote148 views1 answer
Show create table in postgresql
SQL