You need to GROUP them first, then JOIN them:
SELECT t1.ID, t1.ReqNo, t1.TRQ, t2.TIQ
FROM (SELECT ID, ReqNo, SUM(ReqQty) AS TRQ
FROM Table1
GROUP BY ID, ReqNo) t1
JOIN (SELECT ID, IssueNo, SUM(IssueQty) AS TIQ
FROM Table2
GROUP BY ID, IssueNo) t2
ON t1.ID = t2.ID AND t1.ReqNo = t2.IssueNo