SELECT a.idx , b.prd20 , a.prd_cn_Name , a.prdRName FROM nPrdInfo a left outer join nPrdInfoadd b ON a.idx = b.idx WHERE 1 AND length(a.prdCode) = '6' AND b.hView = 'Y' AND b.hKind = 'I' order by a.idx desc
主要产品
  |   회원가입  |   쇼핑몰