The following UNION is working perfectly. But it sure would be nice if I could also use a JOIN to obtain the firstName and lastName from the users table. Is this possible?

Thanks!!


(SELECT date_format(answerDate, '%m-%d-%Y') as dateAdded
, answerDate AS sortDate
, uID
, cID AS entryID
, 'campaigns' AS source
, concat(type, ' Campaign') as type
, answer AS entry
, status
, dateDue
FROM campaigns
WHERE status = 'Open')

UNION ALL

(SELECT date_format(dateAdded, '%m-%d-%Y') as dateAdded
, dateAdded AS sortDate
, uID
, cID as entryID
, 'communications' AS source
, type
, entry
, status
, dateDue
FROM communications
WHERE status = 'Open')
ORDER by sortDate;