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/
 


Kirim email ke