coba ini
insert into tabel1(Kode, Nama)
select tabel2.Kode, tabel2.Nama from tabel2
select tabel2.Kode, tabel2.Nama from tabel2
where tabel2.Kode not in (select tabel1.kode from tabel1);
On 12/7/05, Eko <[EMAIL PROTECTED]
> wrote:
saya punya data misal
tabel1
Kode Nama
GH General Hardware
MC Machinery
tabel2
Kode Nama
GH General Hardware
MC Mchinery
HE Heavy Equipment
CS Conveyor Sistem
gmn caranya insert into data HE dan CS dari table2 ke tabel1
jadi diidentifikasi kode mana yg blm ada di tabel1
saya udah coba pake inner join, dan join2 lainnya tapi msh salah
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/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/
--
dayat
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
