What is wrong with this query?

[bousair]

Hello everybody,

What is wrong with this query?

SELECT * FROM data_vault.hub_artikelnummer art

INNER JOIN (SELECT *
FROM data_vault.sat_artikel_1
WHERE hub_artikelnummer_sqn = art.sqn) aap ON sart1.load_datetime = aap.ldt AND art.sqn = 500

I am getting the following error:

Unknown column 'art.sqn' in 'where clause'

Thank you.

 

[r937]

SELECT * 
  FROM data_vault.hub_artikelnummer AS art
INNER 
  JOIN data_vault.sat_artikel_1 AS aap 
    ON aap.hub_artikelnummer_sqn = art.sqn
   AND aap.ldt = art.load_datetime
 WHERE art.sqn = 500

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon