創建視圖，在視圖設計里面執行SQL提示報錯，
但是通過SQL查詢視圖可以查出來資料。這是什么問題！！怎么解決啊？SELECT DISTINCT
c.GoodsCode, c.GoodsName, c.GoodsSpec, c.Place, c.Manufacturer, qq.STAFFNAME, b.unit, a.BillNo, a.BillSn, a.BillSort, a.GoodsId, a.PackId, t1.BatchCode,
t1.ProduceDate, t1.ValDate, CASE WHEN o.rfruleid = '' THEN 0 ELSE a.Num END AS num, y.Dates AS 出庫日期, q.Dates AS 開票單日期,
yy.Cost * a.Num AS costamt, a.Amount - yy.Cost * a.Num AS profit, a.Price, a.Amount, a.Rate, a.Taxprice, a.TaxAmount, a.Tax, h.BillCode, h.Dates, o.RfBillCode,
y.RfBillCode AS 開票單
FROM dbo.INVOICEDT AS a INNER JOIN
dbo.INVOICEBILL AS o ON a.BillNo = o.BillNo AND a.RfBillNo = o.RfBillNo AND a.EntId = o.EntId LEFT OUTER JOIN
dbo.SALEOUTMT AS y ON o.RfBillCode = y.BillCode AND a.EntId = y.EntId LEFT OUTER JOIN
dbo.SALEOUTDT AS yy ON yy.BillNo = y.BillNo AND a.EntId = yy.EntId AND a.GoodsId = yy.GoodsId AND a.RfBillSn = yy.BillSn LEFT OUTER JOIN
dbo.SALENOTESMT AS q ON y.RfBillCode = q.BillCode AND a.EntId = q.EntId LEFT OUTER JOIN
dbo.STAFFDOC AS qq ON y.SaleManId = qq.STAFFID AND y.EntId = qq.ENTID LEFT OUTER JOIN
dbo.PGPRICE AS b ON yy.GoodsId = b.GoodsId AND yy.PackId = b.PackId AND a.EntId = b.EntId INNER JOIN
dbo.GOODSDOC AS c ON yy.GoodsId = c.GoodsId AND a.EntId = c.EntId LEFT OUTER JOIN
dbo.INVOICEMT AS h ON a.BillNo = h.BillNo AND a.EntId = h.EntId INNER JOIN
dbo.ORGDOC AS d ON d.ORGID = h.OrgId AND d.ENTID = h.EntId LEFT OUTER JOIN
dbo.DEPTDOC AS f ON h.DeptId = f.DEPTID AND h.EntId = f.ENTID LEFT OUTER JOIN
dbo.STAFFDOC AS g ON h.caozy = g.STAFFID AND h.EntId = g.ENTID INNER JOIN
dbo.BUSINESSDOC AS n ON h.RfId = n.BusinessId AND h.EntId = n.EntId LEFT OUTER JOIN
dbo.BATCHCODE AS t1 ON yy.AngleId = t1.AngleId AND yy.GoodsId = t1.GoodsId AND yy.EntId = t1.EntId
uj5u.com熱心網友回復：
有沒有大佬指導下？？？？？
uj5u.com熱心網友回復：
哪位好心大佬幫忙看看啊？？？uj5u.com熱心網友回復：
不要隨便用什么設計， 那樣不專業， 創建和修改視圖， 都用陳述句來完成：
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/9797.html
標籤：疑難問題
上一篇：matlab卡住