>>SELECT xmlpackages.pkey, location.siteid AS Site, location.sitename AS NAME, location.phone, ; >> location.contype AS contype, location.exevers AS ExeVersion, ; >> COUNT(clients.clientno) AS Qty ; >> FROM location ; >> JOIN clients ON clients.siteid=location.siteid ; >> WHERE location.exevers < ; >> (SELECT MAX(RTRIM(majver)+[.]+RTRIM(minver)+[.]+RTRIM(midver)) ; >> FROM xmlpackages ; >> WHERE xmlpackages.pkey between "1000" AND "1999" ) >> AND location.ACTIVE ; >> GROUP BY location.siteid, location.sitename, location.phone, location.contype, location.exevers ; >> ORDER BY location.sitename ; >> INTO CURSOR curLocList >>