If Product_SubFamily is blank in my update table(Middle Table), how can I write the query to update the Channel_Value for main Tbl based on the fields available but also include MR TOM who has a value assigned.
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Strat_Price Sample MainTbl to Update | |||||
Product_Family | Product_SubFamily | Country | Currency | Channel_Code | Channel_Value |
BAR | MR JEAN | US | USD | Store | |
BAR | MR BILL | CA | USD | Markets | |
BAR | MR SMITH | US | USD | Markets | |
BAR | MR JEAN | CA | USD | ||
BAR | MR JONES | US | USD | ||
BAR | MR JONES | US | USD | Markets | |
BAR | MR TOM | US | USD | Markets |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Channel_Value Sample Update Tbl (This table need to update main Channel Values Tbl above) | |||||
Product_Family | Product_SubFamily | Country | Currency | Channel_Code | Channel_Value |
BAR | US | USD | Store | 0 | |
BAR | US | USD | Markets | 40 | |
BAR | MR TOM | US | USD | Markets | 0 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
My Results needed from the Update Tbl | |||||
Product_Family | Product_SubFamily | Country | Currency | Channel_Code | Channel_Value |
BAR | MR JEAN | US | USD | Store | 0 |
BAR | MR BILL | CA | USD | Markets | |
BAR | MR SMITH | US | USD | Markets | 40 |
BAR | MR JEAN | CA | USD | ||
BAR | MR JONES | US | USD | Store | 0 |
BAR | MR JONES | US | USD | Store | 0 |
BAR | MR JOHNSON | US | USD | Store | 0 |
BAR | MR TOM | US | USD | Store | 0 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>