>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