Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple statement but forgot how
axwack_at_gmail.com wrote:
> 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?
You review your homework you've been doing prior to the midterm you were just given. No doubt your instructor provided an example almost identical to this.
I know I would have. ;-)
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Feb 12 2007 - 18:09:37 CST