{Disarmed} Re: [belajar-access] tolong edit queri dr sql mw saya masukin ke acces

 

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

 

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

• New Members 14

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

if(window.yzq_d==null)window.yzq_d=new Object(); window.yzq_d['soUXIUoGYn0-']='&U=13cujqmun%2fN%3dsoUXIUoGYn0-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1';

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.