Updating Help
From: JDoe <x_at_x.com>
Date: Sun, 24 Jun 2001 12:45:25 GMT
Message-ID: <65objtsc70cn5jd97l3t70s5tr77eiltp8_at_4ax.com>
Date: Sun, 24 Jun 2001 12:45:25 GMT
Message-ID: <65objtsc70cn5jd97l3t70s5tr77eiltp8_at_4ax.com>
Hi,
I have these tables in my database
Table A
There is a one-to-one relationship between
A.ID and B.ID
What I would like to do is "copy"
I can't quite make out the update
ID NUMBER(10)
DATA NUMBER(10)
Table B
ID NUMBER(10)
SRC NUMBER(10)
the contents of B.SRC to A.DATA wherever
A.ID = B.ID
query for this. I know using cursors would
work but I'd like to avoid it if possible.
thanks! Received on Sun Jun 24 2001 - 14:45:25 CEST