SQL help

Discussion in 'OT Technology' started by bptillman, Mar 31, 2007.

  1. bptillman

    bptillman New Member

    Joined:
    Apr 7, 2004
    Messages:
    1,966
    Likes Received:
    0
    Location:
    Austin, TX
    ok so ive got two tables and im merging there data together like so

    select * from payment
    union
    select * from payment2

    but when i execute it the resulting file does not have the properties of the previous talbes
    like one field was set to be for dollar amounts but the results one does not. anyway to fix that?
     
    bptillman, Mar 31, 2007
    #1
  2. gnp

    gnp New Member

    Joined:
    Mar 11, 2007
    Messages:
    280
    Likes Received:
    0
    yes
     
    gnp, Mar 31, 2007
    #2
  3. SLED

    SLED custom title

    Joined:
    Sep 20, 2001
    Messages:
    28,123
    Likes Received:
    12
    post definitions of tables
     
    SLED, Mar 31, 2007
    #3
  4. bptillman

    bptillman New Member

    Joined:
    Apr 7, 2004
    Messages:
    1,966
    Likes Received:
    0
    Location:
    Austin, TX
    ?
     
    bptillman, Mar 31, 2007
    #4
  5. Bruticus

    Bruticus half dead OT Supporter

    Joined:
    Apr 10, 2004
    Messages:
    4,607
    Likes Received:
    0
    Location:
    Melbourne
    As sled said, we need more information. Post the table definitions.
     
    Bruticus, Apr 1, 2007
    #5
  6. tuli0

    tuli0 New Member

    Joined:
    Apr 2, 2007
    Messages:
    3
    Likes Received:
    0
    You can also try with UNION ALL, but if the problem is in the table definitions then of course we have to take a look of it to help you.
     
    tuli0, Apr 3, 2007
    #6

Share This Page