SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[VWGoodSimpleLastSummary] AS SELECT derivedtbl_1.GoodSysCode, dbo.VWInvoiceDetailComplete.Fee AS LastFee, dbo.VWInvoiceDetailComplete.InvoiceDate AS LastDate, CASE WHEN NOT FK_AccountSysCode IS NULL THEN Title ELSE customername END AS LastSeller FROM dbo.VWInvoiceDetailComplete INNER JOIN (SELECT GoodSysCode, MAX(SysCode) AS LastSysCode FROM dbo.VWInvoiceDetailComplete AS VWInvoiceDetailComplete_1 WHERE (Type = 2) GROUP BY GoodSysCode) AS derivedtbl_1 ON dbo.VWInvoiceDetailComplete.SysCode = derivedtbl_1.LastSysCode LEFT OUTER JOIN dbo.CodeMNGUPTbl ON dbo.VWInvoiceDetailComplete.FK_AccountSysCode = dbo.CodeMNGUPTbl.AccountSysCode0 GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO