Does the following look right. As a double check I combined the first two programs and made the condition =>2 and I get different numbers to when I run them as below
SELE TEMP.ORDER_NO,TEMP.RECALL,POSTCODE.LEADTIME FROM TEMP,POSTCODE ;
WHERE TEMP.PCODE=POSTCODE.POSTCODE AND POSTCODE.LEADTIME=>3 GROUP BY TEMP.ORDER_NO INTO CURSOR TEMP1
SELE TEMP.ORDER_NO,TEMP.RECALL,POSTCODE.LEADTIME FROM TEMP,POSTCODE ;
WHERE TEMP.PCODE=POSTCODE.POSTCODE AND POSTCODE.LEADTIME==2 GROUP BY TEMP.ORDER_NO INTO CURSOR TEMP1
I look forward to someone helping me.
Thank you
Katie
SELE TEMP.ORDER_NO,TEMP.RECALL,POSTCODE.LEADTIME FROM TEMP,POSTCODE ;
WHERE TEMP.PCODE=POSTCODE.POSTCODE AND POSTCODE.LEADTIME=>3 GROUP BY TEMP.ORDER_NO INTO CURSOR TEMP1
SELE TEMP.ORDER_NO,TEMP.RECALL,POSTCODE.LEADTIME FROM TEMP,POSTCODE ;
WHERE TEMP.PCODE=POSTCODE.POSTCODE AND POSTCODE.LEADTIME==2 GROUP BY TEMP.ORDER_NO INTO CURSOR TEMP1
I look forward to someone helping me.
Thank you
Katie