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: 492
mysql
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