Hi, I am pretty new to SQL.
I am trying to combine two fields in one table and then update a single field in another table with the result.
I wish to make sopdet.nom_sale read as stock.nom_sale_cc and stock.nom_sale_base combined.
The two linking fields are stock.part and sopdet.part