Dear all, Mohon tanya, Saya coba query access dengan memanfaatkan perintah join, tapi dibilangnya koq error, pas saya coba di mysql berhasil dengan baik. Apa karena access tidak mendukung perintah join ???
SQLnya : SELECT nama, tblgr.kodegr AS kode, tblgp.honor AS honor FROM tblnama JOIN tblgr JOIN tblgp WHERE tblnama.kode=tblgr.idxgr AND tblnama.jp=tblgp.jp GROUP BY tblnama.nama Kalo db-nya access : error messagenya : Syntax error in FROM clause (3131). Kalo db-nya mysql : success. Mohon koreksinya... Makasih en wassalam, Darmawan -digestmode- ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
