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.carMaker = B.cate_code
JOIN catetbl M ON G.carModel = M.cate_code
JOIN catetbl V ON G.carVariant = V.cate_code
JOIN filestbl F ON G.seq = F.fileNo
, (SELECT @rownum:=0) TMP
WHERE F.fileRep = 'Y'
ORDER BY rnum desc
;
'기존카테고리 > mysql' 카테고리의 다른 글
INFORMATION_SCHEMA.TABLES (0) | 2018.02.02 |
---|---|
고도에서 workbench use database 선택 (0) | 2017.12.07 |
PDO 출력 및 그룹핑 (0) | 2014.11.10 |
PDO insert 정리 (0) | 2014.11.10 |