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 vote129 views1 answer
Create table as select sql server error
SQL
0 vote158 views1 answer
Psql create usr
SQL
0 vote129 views1 answer
Mysql join column order By and group By
SQL
0 vote122 views1 answer
Wordpress sql change site url
SQL
0 vote124 views1 answer
Oracle running queries sql
SQL
0 vote121 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote124 views1 answer
Oracle exchange partition
SQL
5 votes110 views5 answers
Sqlite install python
SQL
3 votes138 views1 answer
Sql several or
SQL
0 vote144 views1 answer
SQL Cut part string
SQL