Simple statement but forgot how

Folks,

Could someone help me with a sql statement?

I've got two tables:

1. Has member IDs
2. The other Board_ID's

I have a another table that I need to do the following:

for each member ID, insert the board ID and for each board_ID have a member_id.

In other words,

There are 150 members and 100 boards. Each member should get board 1, board 2, etc. but this must loop. How would you do that in an sql statement or do I have to do something more intricate? Received on Mon Feb 12 2007 - 10:12:50 CST