Re: PIVOT tables

A pivot table is just a crosstab query. Lets say I have a couple of tables. One stores information about Employees and the other their sales and the last one shows product information. I want to create a report that will show me how much each employee sells of a particular item. In access you have the ability to create these crosstab queries that look something like this: Product Name Callahan Leverling Suyama Alice Mutton $312.00 Chartreuse verte $86.40 $94.40 Filo Mix $75.60 Gnocchi di nonna Alice $1,094.40 If you want to do a similar query in SQL Server, you can use the PIVOT statement in your SQL. I was just wondering if INFORMIX has this capability. Thanks. Alden