gini aja logikanya.
di table2 kamu bikin satu lagi field berupa flag, namanya terserah misal sts
nah terus kamu buat looping di table2 untuk baca tiap2 record
misal
dim drow1 as datarow
dim drow2 as datarow
for each drow2 in table2.rows
for each drow1 in table1.rows
if drow2("kode") = drow1("kode") then
drow2("sts") = ' * '
end if
next
if drow("sts") = ' * ' then
'insert ke table1
end if
next
mudah2an bisa membantu
Eko <[EMAIL PROTECTED]> wrote:
di table2 kamu bikin satu lagi field berupa flag, namanya terserah misal sts
nah terus kamu buat looping di table2 untuk baca tiap2 record
misal
dim drow1 as datarow
dim drow2 as datarow
for each drow2 in table2.rows
for each drow1 in table1.rows
if drow2("kode") = drow1("kode") then
drow2("sts") = ' * '
end if
next
if drow("sts") = ' * ' then
'insert ke table1
end if
next
mudah2an bisa membantu
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! DSL Something to write home about. Just $16.99/mo. or less
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
