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 vote157 views1 answer
Postgres power
SQL
0 vote127 views1 answer
Difference between varchar and varchar2
SQL
0 vote149 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote166 views1 answer
Oracle extract minute from date
SQL
8 votes143 views2 answers
Python simple connect to mysql
SQL
0 vote161 views2 answers
Search stored procedures by name
SQL
0 vote137 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote134 views2 answers
Tsql row number
SQL
14 votes139 views1 answer
Sql value of string
SQL
1 vote148 views1 answer
Ubuntu access database from terminal
SQL