Error message

[#1]

My problem is an error message is coming up saying Field not found - <PROJECT_ID>. I don't understand why it is not found. Any help would be grateful to resolve the problem.

OP_SUMMART:

Qualify *;

unqualify PROJECT_ID;

LOAD CONTRACT as PROJECT_ID ,

COMPANY_ID,

LABOUR_NO,

PART_NO,

REAL_FINISH,

DELAY_IN_DAYS,

PCT_NOT_APPVD,

QTY_HRS_PLANNED,

QTY_HRS_ACTUAL

FROM

(qvd)

WHERE (LABOUR_NO = 'ASSY RWORK') OR

(LABOUR_NO = 'ASSY ADDS') OR

(LABOUR_NO = 'TEST MODS')

AND

(PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721' );

[#2]

Because at the load time of the statement there is no PROJECT_ID field. There is a CONTRACT field. After that you can use the PROJECT_ID field.

[#3]

How do i write it in the syntax to overcome the error.

[#4]

Are you kidding? Who is writing SQL for you?

All what you need is just replace PROJECT_ID in where clause by CONTRACT.

OP_SUMMART:
Qualify *;
unqualify PROJECT_ID;
LOAD CONTRACT as PROJECT_ID ,
COMPANY_ID,
LABOUR_NO,
PART_NO,
REAL_FINISH,
DELAY_IN_DAYS,
PCT_NOT_APPVD,
QTY_HRS_PLANNED,
QTY_HRS_ACTUAL
FROM

(qvd)
WHERE (LABOUR_NO = 'ASSY RWORK') OR
(LABOUR_NO = 'ASSY ADDS') OR
(LABOUR_NO = 'TEST MODS')
AND
(CONTRACT  = 'S07050720' OR CONTRACT  = 'S07050721' );