本文介绍了在SQL中创建视图时出现Systax错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在SQl中遇到了错误创建视图。下面提到的是我的查询..
我尝试过：
I got an Error Creating view in SQl.The Below Mentioned is my query..
What I have tried:
CREATE VIEW vwbuyerinvoicebankcharges AS
SELECT a.SID AS InvoiceSid,
ISNULL((SELECT ROUND(SUM((ROUND(((b.Amount / c.Amount) * c.BankCharge),5) * c.ExchangeRate)),2)
FROM tblbuyerinvoiceadvancedetail B
JOIN vwadvancemasterwithexrate C
ON C.AdvanceSid = b.AdvanceSid WHERE b.MasterSid = a.SID
ISNULL(SELECT ROUND(b1.NegoBankChargeAmt * b1.ExchangeRate,2)
AS Round(B1.Negobankchargeamt*B1.ExchangeRate,2)
FROM vwbanknegotiationwithexrate B1
WHERE b1.InvoiceSid = a.SID AS NegoBankCharge)
FROM tblbuyerinvoicemaster a GROUP BY a.SID推荐答案
这篇关于在SQL中创建视图时出现Systax错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！