The function the IIF gives me error within the WHERE in the equal sign indicated in red. (Second equal sign after function IIF --> cofaccob.entidad='2578')

select cofaccob.entidad, cofaccob.docemp, sum(cofaccob.haber) as haber from cofaccob where iif(cofaccob.clave='CS', cofaccob.entidad='2578', cofaccob.entidad='2580') group by cofaccob.entidad, cofaccob.docemp order by cofaccob.docemp

As would you solve this problem?

Thank you for everything....
=========
¦¦ ISMAEL ¦¦
=========
----- Mensaje original -----
De: Ismael L. Donis García
Para: firebird-support@yahoogroups.com
Enviado: miércoles, 16 de abril de 2008 03:08
Asunto: [firebird-support] WHERE and IIF


Hi..

The show IIF within the clause where error in Firebird 2,0,3

Does any form to present it unless it happen this exist? Or any one another way to do the consultation with sights to obtain the same result.

=========
¦¦ ISMAEL ¦¦
=========

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]