How do I combine these queries together?

[Tsung90]

Hi, I have 2 queries which I would like to join together, I have tried for hours but I cannot seem to get it to work.

The first query is:

SELECT tblMember.Member_ID,Count(Gym_TicketNo) AS n_Gym
FROM tblMember LEFT OUTER JOIN tblGym
ON tblMember.Member_ID=tblGym.Member_ID
GROUP BY tblMember.Member_ID;

The second query is:

SELECT tblMember.Member_ID, Count(Pool_TicketNo) AS n_Pool
FROM tblMember LEFT JOIN tblPool
ON tblMember.Member_ID=tblPool.Member_ID
GROUP BY tblMember.Member_ID;

How would I join them together? Thanks.

 

[Tsung90]

What do you mean by adding a "value" to each query?

 

[Tsung90]

Sorry, it does work. I mistyped, thank you very much.