1 Reply
Aug 27, 2020 1:43 pm
Can you try this one and let me know?
1. select t1.*
from ISSUES t1
left join ISSUE_HISTORY t2
on t1.ID in t2.(select distinct ISSUE_ID
from ISSUE_HISTORY t2
where t1.ID = t2.ISSUE_ID);