TO SCREEN NOCONSOLE>
> SELECT RZSTOP.* ; > FROM csrInterim ; > LEFT OUTER JOIN mclmpser!RZSTOP ; > ON csrInterim.rte_no == RZSTOP.rte_no ; > AND csrInterim.rte_let == RZSTOP.rte_let ; > AND csrInterim.directn == RZSTOP.directn ; > AND csrInterim.seqno == RZSTOP.seqno ; > WHERE csrInterim.rte_no == lcRteNo ; > AND csrInterim.rte_let == lcRteLet ; > AND csrInterim.directn == lcDirectn ; > AND csrInterim.var_code == lcVarCode ; > AND csrInterim.SeqNo == lnSeqNo ; > NOCONSOLE && 18/04/05 23/12/04 - this should do for just 1 sequence of a var >