Re: Updating Help

hi,

what i suggest to you is
create the column with the specified selection of the data i.e from the first column of the first mentioned table through a query from
friend

JDoe <x_at_x.com> wrote in message news:<65objtsc70cn5jd97l3t70s5tr77eiltp8_at_4ax.com>...
> Hi,
>
> I have these tables in my database
>
> Table A
> ID NUMBER(10)
> DATA NUMBER(10)
>
> Table B
> ID NUMBER(10)
> SRC NUMBER(10)
>
> There is a one-to-one relationship between
> A.ID and B.ID
>
> What I would like to do is "copy"
> the contents of B.SRC to A.DATA wherever
> A.ID = B.ID
>
> I can't quite make out the update
> query for this. I know using cursors would
> work but I'd like to avoid it if possible.
>
> thanks!
Received on Thu Jun 28 2001 - 10:48:37 CEST