Hi,

I have a question about how to select form a subquery. I'm attempting to count the number of times each m_id is returned after running this query:

SELECT m_id
FROM taglink
WHERE m_id <> '25'
AND t_id
IN (
SELECT t_id
FROM taglink
WHERE m_id = '25'
)

The Query returns:
m_id
33
34
34
35
35
35
36

I want to count the number of times that m_id is returned so that the results of my query will be:

m_id | count
33 | 1
34 | 2
35 | 3
36 | 1

In my attempt to do this, I'm trying to run the following query:

SELECT m_id, count( m_id ) AS "count"
FROM (how do I select from the subquery?)
WHERE m_id
IN (
SELECT m_id
FROM taglink
WHERE m_id <> '25'
AND t_id
IN (
SELECT t_id
FROM taglink
WHERE m_id = '25'
)
)
GROUP BY m_id

I'm having trouble getting the syntax right to select from the subquery.

Thanks very much for your time. Your assistance is much appreciated!

This should give you the required output

SELECT m_id, COUNT(*) 
FROM taglink
WHERE m_id <> '25'
AND t_id
IN (
SELECT t_id
FROM taglink
WHERE m_id = '25'
)
GROUP BY m_id