SELECT DC.ServiceID
FROM (SELECT tDataCollection.ServiceID
FROM tDataCollection
WHERE tDataCollection.BatchID = 20100
GROUP BY tDataCollection.ServiceID) AS DC
LEFT JOIN tServiceID ON DC.ServiceID = tServiceID.ServiceID
WHERE tServiceID.TerminationDate IS NOT NULL