Like this
select *, action='also comment', User_Id from CommentTable where Blog_Id in
(select c.Blog_Id from CommentTable c full outer join BlogTable b on b.Blog_Id=c.Blog_Id
where c.User_Id=1 and b.User_Id!=1 )
and User_Id<( select Time from commentTable where UserId=1) order by Date1 desc ,time1 desc
Gokhul VarmanPosted Aug 3, 2017, 9:51 AM
Gaurav RajPosted Aug 3, 2017, 7:49 AM
Vincent Maverick DuranoPosted Aug 3, 2017, 4:09 AM