SELECT tbl_Post_History.Title, CAST (tbl_User_master.First_name+' '+tbl_User_master.Last_name AS VARCHAR(50)) AS [Publisher], tbl_Post_History.Created_datetime, tbl_History_Files.File_name, tbl_History_Files.File_ext, tbl_History_Files.File_Size, tbl_Post_History.Category_id FROM tbl_History_Files INNER JOIN tbl_Post_History ON tbl_History_Files.Post_History_id = tbl_Post_History.Id INNER JOIN tbl_User_master ON tbl_Post_History.User_id = tbl_User_master.Id AND tbl_Post_History.ToUser_id = tbl_User_master.Id WHERE(tbl_Post_History.User_id = '1' OR tbl_Post_History.ToUser_id = '1')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)