>Hi:
>
>When I run the second SELECT I have no problem, but when I run it UNIONed with the first I get an error 'Command is missing required clause'
>
>What am I doing wrong?
>
>Thanx -
>
>Yossi
>
>
>SELECT lm_lotnum FROM it!lottmplt ;
> UNION ;
> SELECT TOP 1 lm_lotnum ;
> FROM it!lotmast ;
> ORDER BY 1 DESC ;
> INTO CURSOR results
>
Yossi,
I think that the TOP n clause applies to the whole query.
If you put it first there is no error. But then, you may not get the result you intended
create cursor pp ( pp I )
local i
for i = 1 to 5
insert into pp values(m.i)
endfor
select top 7 pp ;
from pp ;
order by 1 ;
union all ;
select pp-10 ;
from pp
Gregory