#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    Firebird Crosstab


    I'm working with a database Firebird 2.5 my question and can generate a query or procedures, for example

    my table

    CREATE TABLE COUNTRY
    (REGION VARCHAR2 (20),
    COLOR VARCHAR2 (20))

    INSERT VALUES


    REGION COLOR
    -------------------------------------------------- ----
    Malta RED
    Malta GRAY
    Brazil GREEN ON RED
    Brazil WHITE


    I would like to have this result


    REGION GRAY GREEN ON RED RED WHITE
    -------------------------------------------------- -
    Brazil 0 1 0 1
    Malta 1 0 1 0

    I thank you in advance
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0
    you can create cross-tables in Firebird
    Thanks for any help

IMN logo majestic logo threadwatch logo seochat tools logo