>Hi,
>
>The SQL Select I have that works with VFP does not work with SQL Server database. The SQL statement has HAVING clause. For example (simplified) the following does not work with SQL Server database:
>
>
>select COUND(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition> HAVING TOT_NUM > 5
>
>
>The error is Invalid Column name TOT_NUM. How would I change the above SQL Select make the HAVING working?
>TIA.
select COUNT(DISTINCT WO_NUMBER) AS TOT_NUM
from MyTable
WHERE <SomeCondition>
HAVING COUNT(DISTINCT WO_NUMBER) > 5
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.