Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: cross-tab query syntax

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: cross-tab query syntax

    Originally posted by mrobins
    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.

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    i'm sorry that does't help me to create a cross-tab query.

  4. #4
    Join Date
    Nov 2003
    Posts
    1

    Re: cross-tab query syntax

    Originally posted by mrobins
    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.
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •