>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
>

I get the same error. Apparently you can't use the TOP 1 clause. When I omit it, it works fine.