2006-05-04
164 HIT
|
| select LOG.aFkServiceIDX as idx,CATE.aCateName as cate, COMIC.aComicName as subject, AUTH.aAuthorName as author, LOG.aLogComicIDX cnum, sum(LOG.aCnt) as money from tb_log as LOG, tb_category as CATE, tb_comic as COMIC, tb_author as AUTH where LOG.aLogCateIDX = CATE.aCateIDX and LOG.aLogComicIDX = COMIC.aComicIDX and LOG.aLogAuthorIDX = AUTH.aAuthorIDX group by idx order by idx |

