zura_84 0 Report post Posted June 11, 2008 mcm mane nak join table dan save dlam table yang lain?? maksud nyer ader 2 table nak kena join pastu dh join tu kena save dlm table lain berdasarkan 2 table yang telah d join.. kite dak baru. .... Quote Share this post Link to post Share on other sites
KaMbEnG KeR 0 Report post Posted June 12, 2008 mcm mane nak join table dan save dlam table yang lain?? maksud nyer ader 2 table nak kena join pastu dh join tu kena save dlm table lain berdasarkan 2 table yang telah d join.. kite dak baru. ....try study kat link ni..hrp mmbantu.. w3school Quote Share this post Link to post Share on other sites
arejae 0 Report post Posted June 13, 2008 salam zura, nie pakai database apa ?kalau untuk MS-SQL syntax die camnie.INSERT INTO tableLain (Name,New_IC) select A.Name,B.New_IC FROM table1 A,table2 B WHERE A.Code = B.Codekalau database lain,eheh...kena try test ler dulu. Quote Share this post Link to post Share on other sites