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 vote184 views1 answer
How to subquey to do not load in live database in
SQL
0 vote161 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote173 views1 answer
Mysql workbench not showing schemas
SQL
3 votes155 views1 answer
DB: in eloquent using sql
SQL
1 vote147 views1 answer
Oracle sql create view
SQL
0 vote169 views1 answer
Rabbitmq ui not working
SQL
0 vote123 views1 answer
Store query result in variable sql
SQL
0 vote156 views4 answers
How to connect form to database
SQL
0 vote175 views1 answer
Mysql min value row
SQL
0 vote158 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL