ALTER PROCEDURE [dbo].[ALLDOCUMNETS] AS begin SELECT DocumentInfo.DocID as DocumentID, dbo.DocumentInfo.DocName as DocumentName, dbo.DocumentInfo.Uploadfile as FileUploaded, dbo.DocumentInfo.UploadedBy as UploadedBy, dbo.Userss.Email as UserEmail, dbo.DocType.DocType as Document, dbo.Department.DepType as Department , dbo.Approval.AppoveBy, dbo.ApproveType.ApproveType as Status FROM dbo.Department left JOIN dbo.DocumentInfo ON dbo.DocumentInfo.DepID=dbo.Department.DepID left JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID=dbo.DocType.DocTypeID inner JOIN dbo.Userss on Userss.UserName =dbo.DocumentInfo.UploadedBy inner join dbo.Approval ON dbo.DocumentInfo.DocID = dbo.Approval.DocID INNER JOIN dbo.ApproveType ON dbo.Approval.ApproveID = dbo.ApproveType.ApproveID AND dbo.ApproveType.ApproveType = 'Approve' end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)