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 vote279 views1 answer
Como hacer una consulta en sql
SQL
0 vote274 views1 answer
Mysql preg replace
SQL
3 votes267 views3 answers
Into in sql
SQL
11 votes267 views2 answers
MySQL DISTINCT
SQL
0 vote287 views1 answer
Sql reverse order of results
SQL
0 vote284 views1 answer
Guid string to binary better
SQL
0 vote327 views1 answer
Finding leap year in sql
SQL
0 vote327 views2 answers
Suse Linux restart MySQL
SQL
10 votes272 views2 answers
Reset mysql root password mac
SQL
8 votes288 views1 answer
How to check mysql version in xampp
SQL