Jump to content

SQL to combine two fields into one field in another table.


GJP
 Share

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...