Hello
I want create dummy data from my tables
OFFFER table has Offers
Offer_ID
MEMBER Has
Member_ID
I want create a new table
which contains these types of records
MemberID from MEMBER Table
OFFER_ID from OFFER Table
Sample Table
| MEMBER | OFFERID |
| 1 | 5 |
| 1 | 6 |
| 1 | 7 |
| 1 | 8 |
| 2 | 1 |
| 2 | 2 |
Rules : OfferID cannot be repeated within one Member and Each Member should at least have 2 Offers