Hi to all,
i'm trying to build a cross tab query in Firebird 1.0 but i'm not able to do it.

I want to use something similar to:

SELECT companyname,
SUM (if productname='Box' then 1 else 0) as "BOX",
SUM (if productname='Package' then 1 else 0) as "Package"
...
GROUP BY companyname

but I think that FB 1.0 doesn't support if-then structure nor CASE-WHEN.

Any idea?

Thank you!





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