I'm not sure...did you start a new thread in SQL Server so Sergey or Mike Levy can answer it? *grin*

>>Nadya,
>>
>>I wish you well in this...
>
>Thanks. How to translate:
>

>SELECT MainInfo.*, ;
>sum(iif(MainInfo.Category = "1",1,0)) as Category1Count, ;
>sum(iif(MainInfo.Category = "2",1,0)) as Category2Count ;
>from MainInfo inner join NamesInfo ;
>on MainInfo.CrediID = NamesInfo.CrediID ;
>where MainInfo.ccode = "01" and ;
>MainInfo.town in (select Town from SelectedTowns) ;
>and NamesInfo.LastName like ?NameInput ;
>group by MainInfo.CredID into cursor curResult

>
>into SQL server select command?
>
>(If I'm going to use my data model)
>>
>>>>Does this mean you will be staying with your current employer longer than originally anticipated?
>>>>Tracy
>>>>
>>>They gave me a one month trial period as a WEB developer. If my performance is not going to be adequate, my eployment here will be terminated...
>>>