PIVOT tables

Posted in 1996

neyoisles@aol.com — 2 Dec 1996 19:09:04 GMT — source: Informix-list mailing list archive (1991-1998)

Hi all, We have some crosstab queries that we had created in access for access tables. now that we are migrating our tables to informix, we need to have a way to recreate these crosstab queries using informix tables. I understand that the PIVOT command (in SQL) is used most often using othere database servers. Does anybody know if there is a similar command for Infomix that would allow us to create these PIVOT tables?? We have been unable to do this so far. HELP!! Thanks to all those that respond!! Alden