0

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!

2
Contributors
1
Reply
3
Views
9 Years
Discussion Span
Last Post by mwasif
0

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
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.