JOIN and WHERE

[george55]

Don't understand why can not run this JOIN. Error-Message: C_StartTimeStamp could not be fine. Even if I try with 'XX'. 

And second question. Is this the common way to put a WHERE-Statement by doing it with a if above from Resident/FROM?

DAYINFO:
Load
C_StartTimeStamp as XX
Resident CALL;

LEFT JOIN (DAYINFO)
Load
If(F_StartTime >= C_StartTimeStamp AND F_EndTime <= C_StartTimeStamp, 1, 0)
Resident FEATURE;

[JustinDallas]

Does the table named FEATURE have a field called C_StartTimeStamp?

[george55]

No, FEATURE does not have  C_StartTimeStamp. Is that necessary?

CAL_StartTime is included in Table TAGESINFO. The WHERE-clause should use CAL_StartTime from Table TAGESINFO and not from Table FEATURE.

[JustinDallas]

I would think it would be necessary because you are referencing it in your IF statement.

Load
If(F_StartTime >= C_StartTimeStamp  AND F_EndTime <= C_StartTimeStamp, 1, 0)
Resident  FEATURE ;