SELECT ALL FILE01_A, FILE02_B, SUBSTR(DIGITS(DATE_FIELD),4,2) AS MONTH, FILE02_C, FILE01_D, FILE01_E, FILE01_F FROM FILE01, FILE02 WHERE FILE01_KEY01 = FILE02_KEY01 AND FILE01_KEY02 = FILE02_KEY02 AND (DATE_FIELD >= 1080101 AND CHECK_CODE <> 'AB'')Thanks for any advice on this, Martin Gilbert.
Discuss This Question: 7  Replies