Can anyone tell me how I can perform these two sql statements into one and resulting in one table?
SELECT TEMPALIAS.*, MF_158.DATE_IN AS IMPORTED, 'Record already imported.' AS Errmsg ;
FROM TEMPALIAS, MF_158 ;
WHERE ALLT(TEMPALIAS.UNIQKEYSAS) = ALLT(MF_158.UNIQKEYSAS) ;
INTO CURSOR INMF158 ;
ORDER BY TEMPALIAS.UNIQKEYSAS
m.inmfcnt = _TALLY
SELECT TEMPALIAS.*, MF_158.DATE_IN AS IMPORTED, 'Records previously found as errors but have passed since.' AS Errmsg ;
FROM TEMPALIAS, PROB_158, MF_158 ;
WHERE ALLT(TEMPALIAS.UNIQKEYSAS) = ALLT(PROB_158.UNIQKEYSAS) ;
INTO CURSOR INPR158 ;
ORDER BY TEMPALIAS.UNIQKEYSAS
TIA
Jeff T.
Thanks in Advance.
J. Turner