I have a need a update query that will update the Values column for all products_subfamily except "MR TOM", "US" but still update the Values in all other Product_Subfamilies and Blank Product_Subfamiliy in the US which are not MR TOM with the source update table below. Please assist...Thanks in adavance
My Query:
SELECT DISTINCTROW Strat_Price_Tbl.Product_Family, Strat_Price_Tbl.Product_SubFamily, Strat_Price_Tbl.Country
FROM Strat_Price_Tbl INNER JOIN Channel_Value_TBL ON Strat_Price_Tbl.Product_Family = Channel_Value_TBL.PRODUCT_FAMILY
WHERE (((Strat_Price_Tbl.Product_SubFamily) Not In ("MR TOM")) AND ((Strat_Price_Tbl.Country) Not In ("CA")));
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My Query:
SELECT DISTINCTROW Strat_Price_Tbl.Product_Family, Strat_Price_Tbl.Product_SubFamily, Strat_Price_Tbl.Country
FROM Strat_Price_Tbl INNER JOIN Channel_Value_TBL ON Strat_Price_Tbl.Product_Family = Channel_Value_TBL.PRODUCT_FAMILY
WHERE (((Strat_Price_Tbl.Product_SubFamily) Not In ("MR TOM")) AND ((Strat_Price_Tbl.Country) Not In ("CA")));
CHANNEL_CODE | PRODUCT_FAMILY | PRODUCT_SUBFAMILY | COUNTRY | CURRENCY | CHANNEL_VALUE |
Stores | Bar | US | USD | 0 | |
Markets | Bar | US | USD | 40 | |
Markets | Bar | MR TOM | US | USD | 0 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>