I have two tables. (say TableA
and TableB
)
TableA have 10 rows and TableB have 50 rows.
I want each row in TableA should be joined with X
number of rows from TableB
randomly, so that i get 500 unique results
For example if TableA
has rows (a,b,c)
and TableB
have rows (p,q,r,s,t,u)
and X=2
,then expected result is:
a-p
a-q
b-r
b-s
c-t
c-u
This joining should be random
Aucun commentaire:
Enregistrer un commentaire