首先有两个表：
跟据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写了，所以感觉有些晕头转向的，还有好几个问题呢。。
大神们，谢谢你们了！
------解决方案--------------------
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]
------解决方案--------------------
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]