GJP started following SQL to combine two fields into one field in another table.
GJP posted a topic in SQLHi, 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