Two tables with one shared column data transfer

[eddieadams]

I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1.

select * from tbl1, tbl2 where tbl1.column = tbl2.column;

Above query gives me the results that need to be updated. What will the update statement look like?

[paulnaj]

Hi eddie,

In principle, loop through the first set of results from tbl1 x tbl2 and update tbl2 as you go ... I'd need more info to be precise.

I don't actually think there's any other way but I'd be happy to stand corrected.

Paul. 🙂