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

0 vote152 views1 answer
Sql show founctions
SQL
0 vote149 views1 answer
Laravel eloquent get generated sql
SQL
0 vote141 views1 answer
Postgres create extension if not exists
SQL
0 vote147 views2 answers
What is 1=2 in sql
SQL
1 vote142 views1 answer
Import database from a file using mysql commandline
SQL
0 vote143 views1 answer
Sql create table with references not primary key
SQL
3 votes144 views1 answer
How to find names includes in sql
SQL
0 vote141 views1 answer
Composit key in sql
SQL
8 votes160 views1 answer
Oracle add datafile to tablespace
SQL
12 votes154 views4 answers
How to check mysql version ubuntu
SQL