SELECT dbo.base_CoutureInfo.autoCoutureId, dbo.base_CoutureInfo.CoutureName, dbo.InBill.inbillNO, dbo.InBill.barCode, dbo.InBill.bathcode,
dbo.InBill.invcode, dbo.base_inventory.invname, dbo.base_inventory.invspec, dbo.base_inventory.invunit, dbo.InBill.inQTY, dbo.InBill.inCost,
dbo.InBill.SaleAdvicedPrice, dbo.InBill.inDate, dbo.InBill.re
FROM dbo.InBill INNER JOIN
dbo.base_inventory ON dbo.InBill.autoid = dbo.base_inventory.autoid INNER JOIN
dbo.base_CoutureInfo ON dbo.InBill.coutureID = dbo.base_CoutureInfo.autoCoutureId INNER JOIN
dbo.base_Supplier ON dbo.InBill.supplierID = dbo.base_Supplier.supplierIDautoid 这样查询有数据?
SELECT dbo.base_CoutureInfo.autoCoutureId, dbo.base_CoutureInfo.CoutureName, dbo.InBill.inbillNO, dbo.InBill.barCode, dbo.InBill.bathcode,
dbo.InBill.invcode, dbo.base_inventory.invname, dbo.base_inventory.invspec, dbo.base_inventory.invunit, dbo.InBill.inQTY, dbo.InBill.inCost,
dbo.InBill.SaleAdvicedPrice, dbo.InBill.inDate, dbo.InBill.re
FROM dbo.InBill INNER JOIN
dbo.base_inventory ON dbo.InBill.autoid = dbo.base_inventory.autoid INNER JOIN
dbo.base_CoutureInfo ON dbo.InBill.coutureID = dbo.base_CoutureInfo.autoCoutureId INNER JOIN
dbo.base_Supplier ON dbo.InBill.supplierID = dbo.base_Supplier.supplierIDautoid 有查询结果 你的视图就有结果如果这个没有查询结果,视图就没有查询结果
语法上看不出来有啥或者个把inner join换成 left join 试试看