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.