Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple statement but forgot how

Re: Simple statement but forgot how

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Feb 2007 16:09:37 -0800
Message-ID: <1171325376.307545@bubbleator.drizzle.com>


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.org
Received on Mon Feb 12 2007 - 18:09:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US