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:
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!