http://wenda.tianya.cn/wenda/thread?tid=008e40988f9b74c0 我的问题写在这里了拜托大家看看，上午csnd升级不能用就在天涯上写了。 这里面写了发表不了总说有非法词或词组很郁闷，谢谢大家 FULL JOIN 把数据贴出来
SELECT ISNULL(A.feename,B.feename)feename,ISNULL(A.money,0)-ISNULL(B.money,0) AS money from @TB1 A FULL JOIN @TB2 B ON A.feename=B.feename
竟然发不了表结构,晕 和你一样哦,晕 SQL code: if object_id('[应收费用]') is not null drop table [应收费用] go create table [应收费用]([feename] varchar(8),[money] numeric(5,2)) insert [应收费用] select '管理费',20.00 union all select '速递运费',600.00 union all select '通信费',450.00 if object_id('[应付费用]') is not null drop table [应付费用] go create table [应付费用]([feename] varchar(8),[money] numeric(5,2)) insert [应付费用] select '办 证费',638.79 union all select '附加费用',107.25 union all select '速递运费',555.00
SELECT ISNULL(A.feename,B.feename) AS feename, ISNULL(A.[money],0)-ISNULL(B.[money],0) AS [money] from [�
