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 vote109 views1 answer
Difference between cross apply and inner join
SQL
1 vote125 views1 answer
What is int in mysql
SQL
0 vote125 views1 answer
Mysql aspas simples
SQL
1 vote130 views3 answers
Mysql parse int
SQL
0 vote114 views2 answers
SQL Server Standard
SQL
5 votes129 views3 answers
Create function in postgresql
SQL
3 votes114 views1 answer
MySQL DELETE JOIN
SQL
0 vote125 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote116 views1 answer
Postgresql update to unique
SQL
0 vote154 views1 answer
Download sql file of countries names
SQL