Kevin,

Is it much faster under VFP7? Did you try to run each select separately to see if UNION is responsible for slowdown? See if changing LEFT OUTER JOIN to JOIN speeds up query.

>Hi
>
>I have a 2 UNION'd selects, that are taking an absolute age to process, I don't know if it is the SELECT generally, or if it's the UNION causing it.
>
>

	*Client Search
>	SELECT UPPER(Client.Cl_Sname) AS Cl_Sname,;
>		   UPPER(Client.Cl_Fname) AS Cl_Fname,;
>		   Client.Cl_Dob,;
>		   ALIAS.Al_Sname, ;		
>		   NVL(Property.pr_addr1, SPACE(20)) AS Pr_Addr1,;
>		   NVL(Property.pr_pcode, SPACE(8)) AS Pr_Pcode,;
>		   Client.Cl_Ref ;
>	  FROM Client;
>	  LEFT OUTER JOIN Property  ;
>	    ON Client.pr_code = Property.pr_code  ;
>	  LEFT OUTER JOIN ALIAS  ;
>	    ON Client.Cl_Ref = ALIAS.Cl_Ref  ;
>	 WHERE UPPER(Client.Cl_Sname) = tcCl_Sname ;
>	   AND UPPER(Client.Cl_Fname) = tcCl_Fname ;
>	   AND DTOC(Client.Cl_Dob) = tcCl_Dob;
>	   AND UPPER(Property.Pr_Addr1) = tcPr_Addr1;
>	   AND Property.Pr_Pcode = tcPr_Pcode;
>	 UNION ;
>	SELECT UPPER(Client.Cl_Sname) AS Cl_Sname,;
>		   UPPER(Client.Cl_Fname) AS Cl_Fname,;
>  		   Client.Cl_Dob,;
>		   Alias.Al_Sname,;
>		   NVL(Property.pr_addr1, SPACE(20)) AS Pr_Addr1,;
>		   NVL(Property.pr_pcode, SPACE(8)) AS Pr_Pcode, ;
>		   Client.Cl_Ref ;
>	  FROM Alias ;
>	 INNER JOIN Client ;
>	    ON Alias.cl_ref = Client.cl_ref  ;
>	  LEFT OUTER JOIN Property   ;
>	    ON Client.pr_code = Property.pr_code ;
>	 WHERE ALIAS.Al_Sname = tcCl_Sname   ;
>	   AND ALIAS.Al_Fname = tcCl_Fname  ;
>	   AND DTOC(Client.Cl_Dob) = tcCl_Dob ;
>	  INTO CURSOR recClientList;
> 		 ORDER BY 1,2
>

>
>Any ideas?
>
>Thanks
>Kev