How can I update a source SQL table with data from another table if the data is not a one to one relationship?
e.g. target table – in which the data needs to be entered into
target table has col1 with one row each for ‘a’ and ‘b’