Cacher is the code snippet organizer for pro developers

SELECT [pad_ID]
      ,[pad_Date]
	  ,efsf_Number
	  ,ent_FilePath
	  ,cus_EID
      ,[pad_Status]
      ,[pad_Content]
      ,[pad_RejectInformationSentDateTime]
  FROM [dbo].[BP_PackageData]
  inner join ef_SignedForm on pad_Id = efsf_id
  inner join Customer on efsf_User_ID = cus_Id
  left join BP_PackageEntry on pad_id = ent_PackageId
  WHERE ent_FilePath is null
  ORDER BY [pad_Date] DESC