Re: PIVOT tables

Mik Hobbs <BBT@bbt-ltd.demon.co.uk> wrote in article <tN5ACOA2BHpyEws5@bbt-ltd.demon.co.uk>... > 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 > A PIVOT table is "Microsoft term" (from Excel and SQL server). From the Excel help: A pivot table is an interactive worksheet table you use to summarize and analyze data from an existing list or table A pivot table is somethink like a crosstab. Some RDBMS support pivot tables in their SQL. -- HTH, Pepa Josef Dufek ISS s.r.o., Benesova 2/4, 602 00 Brno, Czech Republic vondr@issbrno.anet.cz