按条件判断表内数据，决定是否插入。
比如有这样两个表，table1,table2
table1有两个字段 table2有两个字段
fname famountfname fmoney
aa100aa630
aa200bb150
aa300cc110
bb200
bb200
cc100
cc100
cc100
现在要将这两个表里的数据合并到一个表上，如下格式。请问这个语句要怎么写呢？
fname famountfmoney
aa630
aa100
aa200
aa300
bb150
bb200
bb200
cc110
cc100
cc100





[解决办法]
order by fname,famount,fmoney desc
[解决办法]
create table tableone
(
fname varchar(10),
famount varchar(10)

)

create table tabletwo
(
fname varchar(10),
fmoney varchar(10)

)

insert into tableone
select
'aa ', '100 'union all select
'aa ', '200 'union all select
'aa ', '300 'union all select
'bb ', '200 'union all select
'bb ', '200 'union all select
'cc ', '100 'union all select
'cc ', '100 'union all select
'cc ', '100 '

insert into tabletwo
select
'aa ', '630 ' union all select
'bb ', '150 ' union all select
'cc ', '110 '

select * from(
select fname,famount, isnull(null, ' ') fmoney
from tableone
union all
select fname,isnull(null, ' ') as famount,fmoney
from tabletwo) A
order by A.fname,fmoney desc
---------------------------------------------
fname famountfmoney
aa630
aa100
aa200
aa300
bb150
bb200
bb200
cc110
cc100
cc100