roh_nanie 0 Report post Posted June 5, 2008 (edited) http://img407.imageshack.us/my.php?image=queryqp1.jpgsaya cuba untuk update id dalam table vendor jika run table query vendor_ade_exp2.tapi keluar error.ada sesiapa boleh tolong?tq Edited June 5, 2008 by roh_nanie Quote Share this post Link to post Share on other sites
arejae 0 Report post Posted June 5, 2008 (edited) err..boleh copy paste dia punya SQL statement utk update tuh tak ? tak berapa nak paham tengok pictures tuh.apa data type utk field id tuh ? Edited June 5, 2008 by arejae Quote Share this post Link to post Share on other sites
roh_nanie 0 Report post Posted June 5, 2008 sql statement : UPDATE vendor LEFT JOIN vendor_ada_exp2 ON vendor.VendorID = vendor_ada_exp2.VendorID SET vendor.id = "2"WHERE (((vendor_ada_exp2.LastOfDate)<=DateAdd("yyyy",-3,Date())));data type id = text Quote Share this post Link to post Share on other sites
arejae 0 Report post Posted June 5, 2008 Salam,saya rasa takder masalah dengan query tuh.sebab saya try ok.tapi of couse dengan sample data yg berlainan dengan awak punya kan. hmm...so saya pun tak sure kenapa awak nyer jadik camtuh. Quote Share this post Link to post Share on other sites