Hi,

I was wondering if anyone knew the INFORMIX syntax required to create a cross-tab query. In MS Access using TRANSFORM and PIVOT functions will create a cross-tab query.

thanx in advance for your help.

Hi,

You refer to "select a.*, b.* from localtable a, remotetable b
where a.key = b.key
................

Where, remotetable= databasename@servername:tablename.
Servername= $INFORMIXSERVER (name of connect for tcp/ip, ipx,....)

Gustavo.

i'm sorry that does't help me to create a cross-tab query.

Try
Select a.key, sum(a.value), sum(b.value) from table1 a, table1 b where a.key = b.key and a.valuename = 'FirstVal' and b.valuename = 'SecVal'

If all the data is from a single table.