I have table1 and table2; I need a result set where for each row in table 1 there will be 1 random value from table 2.
table1
table2
Example:
Desired result set:
(1,c; 2,b; 3,a; 4,a; 5,b)
Aucun commentaire:
Enregistrer un commentaire