I have 2 tables --

table1(my_rowid integer, col2 anything)
table2(my_rowid integer)

I'd like to copy part of my_rowID from table1 to table2, how can I do that? Do I have to use a cursor for loop? Or I can use select...into or insert...into? I tried a few ways but got no luck

Thank you and have a nice weekend!