That comma is mandatory there. It's in fieldlist.
select first_name, last_name from employee
wouldn't error but :
select first_name last_name from employee
or
select first_name, last_name, from employee
would. If you could paste the erroring version it'd be helpfull :)
Cetin
>>Which comma Matthew ? There is no comma after 'from myTable'. Would you paste the code that's not working.
>>Cetin
>>
>>>Is the comma after the 'SELECT myTable, ;' the trick to making this work? I tried and tried to use SUM() 2 times in the same SELECT with VFP giving me errors about unrecognized command verb and syntax. The only difference I can see is that comma.
>>>>
select empno, ;
>>>> sum(iif(code='AB',1,0)) as NumberAB, ;
>>>> sum(iif(code='AB',time,0)) as DurationAB, ;
>>>> sum(iif(code='OT',1,0)) as NumberOT, ;
>>>> sum(iif(code='OT',time,0)) as DurationOT ;
>>>> from myTable ;
>>>> group by empno
Cetin