I am trying to get a Count of all Messages in a User's Trash. (This includes both "Incoming" messages from Others, and "Sent" messages from the User him/herself.)

Here is my query...

Code MySQL:
SELECT COUNT( pm.id )
FROM pm_recipient AS r
INNER JOIN private_msg AS pm ON pm.id = r.message_id
INNER JOIN member AS m_from ON m_from.id = pm.member_id_from
WHERE r.member_id_to = ?
AND r.deleted_on IS NOT NULL
AND r.purged_on IS NULL
UNION
SELECT COUNT( pm.id )
FROM pm_recipient AS r
INNER JOIN private_msg AS pm ON pm.id = r.message_id
INNER JOIN member AS m_from ON m_from.id = pm.member_id_from
WHERE pm.member_id_from = ?
AND sender_deleted_on IS NOT NULL
AND sender_purged_on IS NULL


Unfortunately, it is giving me these two separate results, and I just wanted ONE RESULT (i.e. 18)...

Code MySQL:
COUNT( pm.id )
14
4

Is there a way to do that?

Sincerely,


Debbie