MySQL Query Help, including a count?

Posted by nobosh on Stack Overflow See other posts from Stack Overflow or by nobosh
Published on 2010-05-30T00:21:20Z Indexed on 2010/05/30 0:22 UTC
Read the original article Hit count: 487

Filed under:

Any ideas why this isn't working in MySQL?

SELECT blogentry.*, person.personName, (SELECT * FROM BlogEntryComment Where BlogEntryID = '8') as CommentCount

FROM blogentry INNER JOIN person ON blogentry.personID = person.personID WHERE blogentry.deleted = 'N' ORDER BY blogentry.dateAdded DESC

© Stack Overflow or respective owner

Related posts about mysql