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 vote381 views1 answer
Trigger stock phpmyadmin
SQL
1 vote356 views1 answer
Get last week data in mysql
SQL
2 votes400 views2 answers
Sqlalchemy return id after insert
SQL
3 votes356 views1 answer
Mssql remove column
SQL
3 votes389 views1 answer
Laravel database Using Named Bindings
SQL
1 vote358 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote381 views1 answer
Sql server insert inner join
SQL
1 vote338 views1 answer
Mysqli connect
SQL
0 vote453 views1 answer
Compress sql file database ubuntu
SQL
0 vote370 views1 answer
Sql convert datetime to year
SQL