SQL Server ºÏ²¢½á¹û¼¯ - MS-SQL Server / ÒÉÄÑÎÊÌâ

select b.AccountantID,dbo.hidtelpart(a.tel),midreceivedate,
isnull(c.enddate,Dateadd(yy,1,midreceivedate)) as enddate,
b.bankdate ,a.amount,DateDiff(mm,midreceivedate,enddate)as m
from dbo.AccountantFinal as a
 join dbo.Accountant as b on a.SourceID=b.AccountantID
 --join CustomerExtend as c on a.tel=c.tel
 join dbo.AccountReport as c on a.AccountantID=c.AccountantFinalID
 where DateDiff(mm,getdate(),b.BankDate)=0  
 

select Amount,AccountantID from dbo.Accountant 
where AccountantID not in (select SourceID from dbo.AccountantFinal ) 
and DateDiff(mm,getdate(),BankDate)=0

select Amount,AccountantID,b.num,Amount-b.num from dbo.Accountant as a join (
select SUM(Amount) as num,SourceID from dbo.AccountantFinal 
where DATEDIFF(mm,GetDate(),ReceiveDate)>=-3 group by SourceID) as b on a.AccountantID=b.SourceID
 and a.Amount>b.num
 where DateDiff(mm,getdate(),a.BankDate)=0 



ÕâÈýÌõSQLÓï¾äºÍ²¢³ÉΪ´æ´¢¹ý³Ì 
񻂗
ÏÔʾÁÐÒÔµÚÒ»ÌõΪÖ÷ µÚÒ»ÌõûÓеĻ°Ìí¼ÓÉÏÈ¥
ûÓÐÊý¾ÝµÄÏÔʾΪ¿Õ

---

union all

---

SQL code:
select a.*, b.* , c.* from a left outer join b on a.**** = b.**** left outer join c on a.**** = c.****
Ū¸ö±ðÃû ÔÙǶÌײéßÂ

---

ºÏ²¢£ºunion all&nb