Re: Oracle SQL: UPDATE using Subquery or Join
From: hyun <hyun3688_at_hotmail.com>
Date: 28 May 2003 17:30:02 -0700
Message-ID: <cbf43764.0305281630.163a8948_at_posting.google.com>
Date: 28 May 2003 17:30:02 -0700
Message-ID: <cbf43764.0305281630.163a8948_at_posting.google.com>
i think ^^*
update A
set A.name = (select B.name
from A, B
where A.id = B.id)
where A.id = (select B.id
from A, B
where A.id = B.id)
Received on Thu May 29 2003 - 02:30:02 CEST