Am using a UNION query to collate two disparate queries, and then want to use that query nested within another. This is what I have:
SELECT DISTINCT cid, logdt, MIN(closedt) FROM
(
SELECT cid, logdt, closedt
FROM Call C
WHERE datediff(ss, C.logdt, C.closedt) < 21600
UNION
SELECT c.cid...