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
(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
__._,_.___
SPAM IS PROHIBITED
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar