link between msc_supplies and msc_sup_dem_entries
I need to update the task_id and project_id from msc_supplies table into project_number and task_number fields of msc_sup_dem_entries table.Please can you advice how this can be done. Is there any way I can join these tables?
Regards,
Debarati