>Hi folks,
>
>Vfp 7 help file mentions about parenthesis to combine multiple unions in select sql command.
>
>I can't get it to work. Please help...
>
The parenthesis are not required. The following SELECT doesn't make much sense but demonstrates the use of UNION.

USE( Home(2) + "\data\employee")
SELECT * FROM employee WHERE last_name = "B" ;
UNION ;
	SELECT * FROM employee WHERE last_name = "P" ;
UNION ;
	SELECT * FROM employee WHERE last_name = "M"