SELECT @rownum:=@rownum
SELECT @rownum:=@rownum+1 AS rnum, G.seq, G.userId, G.carMaker, G.carModel, G.carVariant , U.firmId firmId, U.firmName firmName , B.cate_code cate_code, B.cate_name carMaker, M.cate_code cate_code, M.cate_name carModel , V.cate_code cate_code, V.cate_name carVariant , F.seq fileSeq, F.sort, F.fileNo, F.storedFilename FROM goodstbl G LEFT JOIN firmtbl U ON G.userId = U.firmId JOIN catetbl B ON G...
더보기