TECH SQL help

[bptillman]

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?

 

[gnp]

yes

 

[SLED]

post definitions of tables

 

[bptillman]

yes

?

 

[Bruticus]

As sled said, we need more information. Post the table definitions.

 

[tuli0]

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.