SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[VWInvoiceDetailComplete] AS SELECT dbo.invoiceDetailTbl.GoodSysCode, dbo.invoiceDetailTbl.Quantity * dbo.InvoiceTbl.Sign * dbo.invoiceDetailTbl.UnitRate AS NetQuantity, dbo.invoiceDetailTbl.Fee, dbo.invoiceDetailTbl.SerialNo, dbo.invoiceDetailTbl.Size, dbo.invoiceDetailTbl.Color, dbo.invoiceDetailTbl.WareHouse, dbo.InvoiceTbl.Amani, dbo.InvoiceTbl.Type, dbo.InvoiceTbl.FK_DocsysCode, dbo.InvoiceTbl.InvoiceDate, dbo.InvoiceTbl.CustomerName, dbo.InvoiceTbl.InvoiceSerialNo, dbo.InvoiceTbl.FK_AccountSysCode, dbo.invoiceDetailTbl.SysCode FROM dbo.invoiceDetailTbl INNER JOIN dbo.InvoiceTbl ON dbo.invoiceDetailTbl.FK_InvoiceSysCode = dbo.InvoiceTbl.InvoiceSerialNo GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO