스타일링(왁스,에센스,젤,스프레이,투페이스)
Select Top 100 * from shop_item_list a, shop_prdt_info b where a.it_code = b.it_code and status in ('Y') and a.it_code not in (select top 0 a.it_code from shop_item_list a, shop_prdt_info b where a.it_code = b.it_code and status in ('Y') and left(categorycode,3)='006' and categorycode='006001000000' order by DISPLAY_SEQ_CATE2) and left(categorycode,3)='006' and categorycode='006001000000' order by DISPLAY_SEQ_CATE2자료가 없습니다. |