Hi..
coba pakai sintax ini:
update A
set A.umur=B.umur
from A
inner join B on
(A.kode=B.kode)
semoga membantu
--aL--
--- Andhi Y <[EMAIL PROTECTED]> wrote:
>
> Rekan-rekan,
>
> Bagaimana syntax SQL untuk update tabel dimana ambil
> datanya dari tabel yang
> lain. Misal,
> Tabel A:
> Kode Nama Umur
> 001 AAAA -
> 002 BBBB -
> 003 CCCC -
> 004 DDDD -
> 005 EEEE -
>
>
> Tabel B:
> Kode Umur
> 001 10
> 003 23
> 004 18
>
> Jika saya ingin meng-update Tabel A, hasil yg saya
> inginkan:
> Tabel A:
> Kode Nama Umur
> 001 AAAA 10
> 002 BBBB -
> 003 CCCC 23
> 004 DDDD 18
> 005 EEEE -
>
> Mohon bantuannya....
> Thanks.
>
>
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
