>>>Hi Fox maniacs
>>>
>>>I have the below select command. All I'm interested in is the _TALLY so I throw the results away. I'm doing several of these in a loop. Proble is the "NOCONSOLE" clause seems to be ignored and I'm getting every result set up in a browse window.
>>>
>>
>>Then,
>>- why LEFT JOIN ?
>>- why RZSTOP.* ?
>
>Cos I want to know how many RZStop recs there are for each of the csrInterim recs, with the given keys
>I don't really understand the popint of the question.
>>

Right, but if exist 1 csrInterim recs and 0 RZSTOP recs, _TALLY return 1 !

try this:

 SELECT COUNT(RZSTOP.rte_no) ; && RZSTOP's pk
   INTO ARRAY countRZSTOP;
    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