Re: PIVOT tables

Posted in 1996

Mik Hobbs — Tue, 3 Dec 1996 18:24:54 +0000 — source: Informix-list mailing list archive (1991-1998)

I've been using Informix for 7 years and have never heard of pivot tables. What exactly are you trying to do ? It sounds like a many to many relationship that you're trying to handle ? How about posting a description of the tables and the SQL that you're trying to run. Mike. In article <19961202191000.OAA18359@ladder01.news.aol.com>, neyoisles@aol.com writes >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 -- Mik Hobbs