title: how to replace a column of data with another column from another table?
body: <p>I have two tables, tbl1(col1, col2, col3), tbl2(col1). I need to replace the data of tbl1.col1 with the data from tbl2.col1. My problem is there is no common field to join the two tables. Is it possible to write a query to do the update?</p>