SQL to combine two fields into one field in another table. in SQL Posted July 16, 2018 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
SQL to combine two fields into one field in another table.
in SQL
Posted
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