Kalau saya, saya pakai fasilitas sql view ms Access. Klik object query > Double klik Design view > Show Table > pilih close > Klik menu baru View > pilih sql view > paste sql disini > Klik view.
Kalau muncul error, amati pesan yang muncul. Cari jalan keluar berdasarkan error tersebut. Error muncul karena ada sedikit perbedaan antara query Ms Access dan sql.
Semoga bisa membantu dan memberi semangat.
Hariyanto (Surabaya)
MailScanner warning: numerical links are often malicious: http://110.139.57.19
From: Anxgundul Ganteng <anxgunduls@yahoo.co.id>
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Sent: Monday, 28 November 2011, 12:54
Subject: [belajar-access] tolong edit queri dr sql mw saya masukin ke acces
Salam kenal.
saya mw nanya bagaimana merubah bahasa query sql menjadi query acces.
sy mencari data dr dua tabel yg salah satunya belum di proses.
contoh query sql :
select a.potreg, a.potnpwp, a.potthpj, a.potmspj, a.potnott from
(select potreg,potnpwp,potthpj,potmspj,potnott from fsptpot21 group by potreg,potnpwp,potthpj,potmspj,potnott) a
left outer join
(select isireg,isinpwp,isithpj,isimspj,isinott, 'RKM' as STATUS from fisipot21 group by isireg,isinpwp,isithpj,isimspj,isinott) b
on (potreg||potnpwp||potthpj||potmspj||potnott=isireg||isinpwp||isithpj||isimspj||isinott)
where b.status is null
sudah sy coba tidak bisa d masukan ke acces.
trima kasih
Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
No comments:
Post a Comment