Multi SELECT statement problem subquery issue need help urgently

I want to return the count of a tag in a sub routine that corresponds to single result set like so.

SELECT sys_Objects_Tags.TagID, sys_Tags.TagName,
    (SELECT COUNT(*)
        FROM sys_Objects_Tags
        INNER JOIN sys_Tags ON sys_Objects_Tags.TagID = sys_Tags.TagID
        WHERE sys_Objects_Tags.SystemObjectID = @BlogID
        GROUP BY sys_Objects_Tags.TagName
    ) Count // <- this column here need to be called "Count" I just need the count here of how many times the tag occures
From sys_Objects_Tags
INNER JOIN sys_Tags ON
sys_Objects_Tags.TagID = sys_Tags.TagID
WHERE sys_Objects_Tags.SystemObjectID = @BlogID AND
sys_Objects_Tags.SystemObjectRecordID = @BlogEntryID
AND sys_Objects_Tags.TableName = 'Blog'
GROUP BY sys_Objects_Tags.TagID, sys_Tags.TagName

Re: Multi SELECT statement problem subquery issue need help urgently

Hi Sir ,

can give us a schema about the fields those you're working on .

Re: Multi SELECT statement problem subquery issue need help urgently

Please refer this areticle, I think it can help you solve this issue,

http://forge.mysql.com/wiki/TagSchema