>>Hi,
>>
>>I have the following SQL Select code when using VFP database and it works:
>>
>>

>>select Mytable.myfld1 + Mytable.myfld2 as MyGroup from MyTable group by MyGroup
>>

>>
>>When executing this SQL Select against SQL Server it fails. How do I change this SQL Select so that it would work for both VFP and SQL Server?
>>
>>Thank you in advance.
>
>

Select MyField1 + myField2 from myTable group by MyField1 + myField2

>
>works, I just tried.
>
>Another way
>

>select MyGrp from (select myFld1 + MyFld2 as myGrp from Signs ) Test group by MyGrp

I tried another approach, selecting each field and then group on fld1 and fld2 as following:

Select MyField1, myField2 from myTable group by 1,2

But I get error that Group By expression must contain at least one column that is not an outer reference. My example above is simplified as I have 2 JOINS in the SQL Select. So I need to understand how to change the JOIN to make it work.

Thank you for your suggestions.

UPDATE: The solution was to use the field names in GROUP BY as:

Select MyField1, myField2 from myTable group by MyField1, myField2