set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[STPGridList_DocDetailChange] AS SELECT ChangeDocDetailTbl.Syscode, ChangeDocDetailTbl.Fk_docSysCode AS DocumentCode, ChangeDocDetailTbl.Fk_AccountSyscode, ChangeDocDetailTbl.AmmountIN, ChangeDocDetailTbl.AmmountOUT, ChangeDocDetailTbl.UserRowNo, ChangeDocDetailTbl.ArchiveName, CodeMNGDWNTbl_1.Title AS SndTitle, CodeMNGDWNTbl.Title AS AccountTitle, Users_1.UName AS OnChangeUName, ChangeDocDetailTbl.OnChangeUserId, ChangeDocDetailTbl.IsUpDated, ChangeDocDetailTbl.OnChangeSysDate, ChangeDocDetailTbl.Comment, CodeMNGUPTbl.Title AS AccountUpTitle FROM CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN CodeMNGUPTbl RIGHT OUTER JOIN CodeMNGDWNTbl ON CodeMNGUPTbl.AccountSysCode0 = CodeMNGDWNTbl.FK_AccountSysCode0 RIGHT OUTER JOIN ChangeDocDetailTbl ON CodeMNGDWNTbl.AccountSysCode = ChangeDocDetailTbl.Fk_AccountSyscode ON CodeMNGDWNTbl_1.AccountSysCode = ChangeDocDetailTbl.SndFk_AccountSyscode LEFT OUTER JOIN Users AS Users_1 ON ChangeDocDetailTbl.OnChangeUserId = Users_1.UID