Here is updated Query :
DECLARE @ischecked BIT =1
SELECT
ticketmaster.id as ticketid,
ticketmaster.ticketnumber as ticketnumber,
ticketdetail.subject as subject,
ticketmaster.priority as priority,
ticketmaster.status as status,
ticketdetail.createddate as lastupdated,
Distributor.Name as Company
FROM ticketmaster
LEFT JOIN ticketdetail ON ticketmaster.ID = ticketdetail.ticketmasterid
LEFT JOIN Distributor ON ticketmaster.distributorid=Distributor.ID
WHERE ticketmaster.status IN (0,1) AND ((ticketmaster.distributorid=0 AND
ticketmaster.issamelevel=1) OR (@ischecked =1 AND (ticketmaster.distributorid<>0 AND
ticketmaster.issamelevel=0 AND resellerid=0)))
GROUP BY ticketmaster.id as ticketid,
ticketmaster.ticketnumber as ticketnumber,
ticketdetail.subject as subject,
ticketmaster.priority as priority,
ticketmaster.status as status,
ticketdetail.createddate as lastupdated,
Distributor.Name as Company
HAVING MAX(ticketdetail.createddate)=1
select * from ticketmaster
Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are always welcome.
Thanks & Regards
RDBurmon.Sr.Software Engineer