I have two scripts.
The first is to update the table temp_forecast_time with the (qtyshipped-qtyreturned) and the second is to update the table temp_forecast_time with netforecastquantity.
Both scripts giving me the results that I want however I need the both of them to run to update the coloum opensalesforeast.
left join forecast_sales_temp on
forecast_sales_temp.saleslocation=temp_forecast_time.saleslocation and forecast_sales_temp.itemno=temp_forecast_time.itemno and forecast_sales_temp.invoicedate=temp_forecast_time.lastinvoicedate and
from temp_forecast_time left join ASB_VSAFCDT on
Both of them works when run separate, but if you run the first script you get the results I want when I run the second script it replace the results of the first.
What to do to prevent that ????
I try adding when opensalesforecast is null, but nothing.
PLEASE HELP !!!!!!!!!