Firstly I would like to thank all of u for the repsonses.
I know that using reserved words is a bad idea , but i have fixed all of that.
I actually printed a list of reserved words and worked backwards from there.
By the way Nadya I am not a girl, but don;t worry I have other people that even call me Fido(like in the dogs name)
No harm done :)
Regards
Fida
>>Hi All
>>
>>Can anyone please help with this statement :
>>
>>I get an error say unrecognised phrase/keyword .
>>
>>select group_.gcode,group_.desc_,sum(assets.price) for (empty( assets.trans_sold) .or. assets.trans_sold = "I" .or. isnull(assets.trans_sold)), ;
>>sum(assets.depprevyrs) for assets.trans_sold = "S" ;
>>from group,assets ;
>>where assets.group_ = group_.gcode
>>
>>Thanks in advance
>>Fida
>
>In addition to Macer's comments, I see two other problems with this query. First, you refer to a table as Group in the FROM clause, but Group_ in other places.
>
>Second, if the real name is Group, you're likely to have trouble with any query involving this table because GROUP is a reserved word in queries. In general, it's a bad idea to use VFP reserved words as table or field names.
>
>Tamar
Wannabe FoxPert!!!