Member Avatar for hoopsnerd

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
  • 81 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for mwasif

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.