GJP Posted July 16, 2018 Share 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 Link to comment Share on other sites More sharing options...
niche Posted July 16, 2018 Share Posted July 16, 2018 https://www.w3schools.com/sql/sql_alter.asp Then, use the CONCAT_WS keyword Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now