Forum Discussion
SQL - removing data
Hi all, I have this SQL shown below. Only problem is that there is a problem with 2 of the days with 2 specific style. Is there a way to remove style numbers 12170151 and 12138940 for the day...
hi imlaug
Add a conditioanal as below:
SELECT TTL_CALC_COST,
STOCK_AGE,
COLLECTION_NAME,
COLLECTION_TERM,
STOCK_DATE,
STOCK_COUNTRY_NAME,
QUANTITY_TYPE,
WAREHOUSE_NAME,
SUPPLY,
ASSRTMNT_TYPE_NAME,
QUANTITY,
TTL_WHS_EUR,
BRAND_NAME,
STYLES_ID,
SALES_TYPE,
COUNTRY_CMP,
STYLE_CATEGORY_NAME,
STYLE_SUBCATEGORY_NAME,
STYLE_TYPE,
STYLE_NUMBER,
STYLE_NAME,
COLLECTIONS_ID,
ASSORTMENTS_ID,
ASSORTMENT_NAME,
CUSTOMER_GROUPS_ID,
GROUP_NAME,
SUBDEPARTMENT_ID
FROM DISCOVER.DISC_STOCK
Where (SUBDEPARTMENT_ID = '21') AND (STOCK_DATE <> '23-12-2019' OR (STYLE_NUMBER<>12170151 AND STYLE_NUMBER<>12138940))
AND (STOCK_DATE <> '23-12-2019' OR (STYLE_NUMBER<> 12170151 AND STYLE_NUMBER<>12138940))
Regards,
Lin