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

2 votes340 views2 answers
Set value to null sql
SQL
1 vote290 views1 answer
Oracle avg
SQL
0 vote306 views1 answer
Apex for oracle 11g
SQL
0 vote292 views1 answer
Drop specific row postgresql
SQL
0 vote267 views1 answer
What is the essence of SQL?
SQL
15 votes434 views2 answers
Sql order by alphabetical
SQL
0 vote278 views1 answer
Update set with inner join oracle
SQL
7 votes288 views6 answers
Nth highest salary in sql
SQL
0 vote303 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
11 votes287 views3 answers
Sqlite3 create table from another table
SQL