SELECT Q.SEQ, Q.SUBJECT, Q.NAME, DATE_FORMAT( Q.INSERTDT, '%Y-%m-%d' ) INSERTDT, Q.PUBLICYN
, (SELECT COUNT(QC.P_SEQ) FROM TB_QNACOMT QC WHERE QC.P_SEQ = Q.SEQ) as COMTCNT
FROM TB_QNA Q
ORDER BY Q.SEQ DESC
LIMIT 0, 15
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(QC.P_SEQ) FROM TB_QNACOMT QC WHERE QC.P_SEQ = Q.SE
버전은 MySQL 4.0.26-standard 입니당
|