MS ACCESS MAILING LIST: {Disarmed} [belajar-access] tolong edit queri dr sql mw saya masukin ke acces

Thursday, December 1, 2011

{Disarmed} [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 (6)

Recent Activity:

New Members 13

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['aR6YMEoGYrI-']='&U=13c0ch65m%2fN%3daR6YMEoGYrI-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1';