Compare and Update

MrMix's profile image MrMix posted 4 years ago in General Permalink

Hello, I can't figure out how write a query where I can update some lines after comparing two columns.

I have a db named 'nolim' with two tables 'product' and 'income'.

The table 'product' has several columns among which 'path' and 'rate'.

The table 'income' has several columns among which 'line' and 'quote'.

Now here what I'd like to do:

if the field (txt) in column 'line' of 'income' table is the same of 'path' in 'product' table than the value into 'quote' should be copied into 'rate'

See attached txt file as an example

Thank you for your help.

MM

1 attachment(s):

Please login to leave a reply, or register at first.