How to update a column in a table with data from another, unrelated tables columns data jus in order it selected?
Create a column in each table that you can update with a sequence. Then you have something to join on.