On Mon, Nov 21, 2005 at 15:53:15 -0800,
Bob Pawley <rjpawley@shaw.ca> wrote:
> I want to take the serial ID of several values in different rows in one table and insert them into a single row of
anothertable.
>
> Would the 'group by' command be the best way to do this?
From your description I think it is more likely you want to use subselects.