select *, (SELECT COUNT(bseq) FROM TB_TRAVEL_Comt WHERE bseq = q.bseq) AS cmt_cnt from TB_TRAVEL q where bseq = 10

여행정보