>>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
>
What I didn't write in my initial message and that probably makes a difference is that I have GROUP BY clause. And therefore, the TOT_NUM is a grouped value. So I am not sure if the above will apply.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham