大神们，我想继续求助

[阿遇]

首先有两个表：


跟据INVOICE及PAID表的纪录，写出SQL SELECT语句，得出这个“销售付款表＂

我的语句是这样子的：

Select [INVOICE].[Invoice No],[PAID].[Invoice Data],”SALES:”+Category+” - ”+Content as Detail,[Inv] inner join orders on  [INVOICE].[Invoice No]= [PAID].[Invoice Data] order by [Invoice Data]

请问哪里错了呢？可以教教我吗？正确的应该是怎样呢？
因为之前是用VFP写的，而现在转用SQL Server写了，所以感觉有些晕头转向的，还有好几个问题呢。。
大神们，谢谢你们了！

[阿遇]

真是太感谢了！我还有几个问题呢，拜托你们了！

[lzw_0736]

""改為''試試

[--小F--]

SELECT
 [INVOICE].[Invoice No],[PAID].[Invoice Data],'SALES:'+Category+' - '+Content as Detail,[Inv]   FROM 表名
 inner join orders on  
 [INVOICE].[Invoice No]= [PAID].[Invoice Data] 
 order by 
 [Invoice Data]

[chuanzhang5687]

你想要的结果是什么

[阿遇]

就是根据上面的两个表，得出最下面那个表， 的SQL Select语句， 请问可以教我吗？谢谢啦！

[sedshy]

select * from
(
select [Invoice No], [Invoice Date],  'SALES: '+ Category + '-' + Content as Detail, Amount as Inv, 0 as Pay
from Invoice
union all
select [Receipt No] as [Invoice No], [Receipt Date] as [Invoice Data],  'PAID: '+ [Invoice No] + ' BY ' + [Paid By] as Detail, 0 as Inv, Amount as Pay
from Paid 
) a
order by [Invoice Date]