Jump to content

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

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

Share this post

Link to post
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