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 :rolleyes:
Thank you and have a nice weekend!