sql - Insert values from one column to another column in a different table -


please can assist ,

i have 2 tables, item table , import table many rows

i need insert import.price item.buydownprice

where import.barcode = item.itemlookupcode

kind regards

it sounds confusing concepts. inserting values 1 table's column table's column straightforward. however, in context, where condition wouldn't make sense.

it sounds me (but tell me if i'm wrong) trying add price column item table join:

select a.*, b.price buydownprice item left join import b   on a.itemlookupcode = b.barcode 

Comments

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

reflection - How to access the object-members of an object declaration in kotlin -

php - Doctrine Query Builder Error on Join: [Syntax Error] line 0, col 87: Error: Expected Literal, got 'JOIN' -