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

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...