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?
     
  2. gnp

    gnp New Member

    Joined:
    Mar 11, 2007
    Messages:
    280
    Likes Received:
    0
    yes
     
  3. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    post definitions of tables
     
  4. bptillman

    bptillman New Member

    Joined:
    Apr 7, 2004
    Messages:
    1,966
    Likes Received:
    0
    Location:
    Austin, TX
    ?
     
  5. Bruticus

    Bruticus half dead OT Supporter

    Joined:
    Apr 10, 2004
    Messages:
    4,608
    Likes Received:
    0
    Location:
    Melbourne
    As sled said, we need more information. Post the table definitions.
     
  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.
     

Share This Page