Why am I getting 'Field 'ADC_KEY' not found' in the following code?

[aschmeelk]

Code:

gra_customer_info_settings:

LOAD *  

FROM [lib://Snider - QVDs (win000294_aschmeelk)/gra_customer_info_Settings.qvd]

(qvd);

Left Join (gra_customer_info_settings)

Load

  [Customer Code]           AS ADC_CODE,

  [Customer Name]           AS ADC_NAME,

  ASSOCIATED_TO      AS ADC_KEY

Resident gra_customer_info_settings

Where ADC_KEY = CUSTOMER_INFO_SETTINGS_KEY;

I get this error whether I prepend the table name to the field or not.

I am missing something, but what?  I have searched through the community for an answer to this, but so far, haven't found any answers.

Any/all help will be greatly appreciated!

[balabhaskarqlik]

The Where condition is wrong.

Try:

Where ASSOCIATED_TO = CUSTOMER_INFO_SETTINGS_KEY;