TECH SQL help

bptillman

Active Member
Apr 7, 2004
1,955
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?
 

tuli0

New Member
Apr 2, 2007
3
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.
 

Users who are viewing this thread

About Us

  • Please do not post anything that violates any Local, State, Federal or International Laws. Your privacy is protected. You have the right to be forgotten. Site funded by advertising, link monetization and member support.
OT v15.8.1 Copyright © 2000-2022 Offtopic.com
Served by fu.offtopic.com

Online statistics

Members online
438
Guests online
75
Total visitors
513

Forum statistics

Threads
369,753
Messages
16,917,885
Members
86,875
Latest member
ddunn9448