如何使用Union all或任何新解决方案组合3个查询

Question

I have 3 Queries Like

SELECT count(*) AS Notificationcount  FROM notifications WHERE email='$email'    and seen='NO' 
    UNION ALL
    SELECT count(*) AS MessageCount FROM messages WHERE email_to='$email' and seen='NO'
    UNION ALL
    SELECT count(*)  AS FriendsCount from friends where profileid2='$email' and requeststatus='pending'

I wanted To combine 3 queries Result Into one How can we do that Thanks in advance

Answer 1

select 
(SELECT count(*) AS Notificationcount FROM notifications WHERE email='$email' and seen='NO') as a,
(SELECT count(*) AS MessageCount FROM messages WHERE email_to='$email' and seen='NO') as b,
(SELECT count(*) AS FriendsCount FROM friends where profileid2='$email' and requeststatus='pending') as c