Mysql – How to update a column in a table with data from another, unrelated tables columns data jus in order it selected


There are two tables that unrelated. I want to update a field in first table with data that selected from second table in some order. There is no relations between tables, fields and data.
I have just errors from my try outs.
PS: Using MySQL.

Best Answer

Create a column in each table that you can update with a sequence. Then you have something to join on.