Hi Fida,

Nice to see your face here in UT. I mistakenly thought, that you're a girl. Perhaps, Fida reminds me Frida :)

Regarding your question: You can not use FOR clause in SQL, you have to place all your conditions in WHERE clause.

>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