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