Siang,
coba dgn select statement berikut:
select * from table where voucher in (select distinct voucher from table where jurnal = "PPh 23")
Semoga membantu,
Cokro
From: "jhony.excel@yahoo.co.id" <jhony.excel@yahoo.co.id>
To: belajar-access@yahoogroups.com
Sent: Thursday, 26 September 2013, 11:03
Subject: [belajar-access] Query Menampilkan semua Voucher yang ada pph 23 nya
To: belajar-access@yahoogroups.com
Sent: Thursday, 26 September 2013, 11:03
Subject: [belajar-access] Query Menampilkan semua Voucher yang ada pph 23 nya
Selamat Siang Semua,
Saya mau menanyakan bagaimana query utk menampilkan data yg kena pph 23 contoh tabel :
Voucher ket. D/K Jumlah Jurnal
AA1. Jasa. D. 2.500 By Kantor
AA1. Jasa. D . 250. PPn
AA1. Jasa. K. 50. PPh 23
AA1. Jasa. K. 2.700. A/P
AA2. Meja. D 2.500 Fixed asset
AA2. Meja. D 2.500 PPn
AA2. Meja. D 2.500 A/P
AA3. Jasa. D. 6.500 By Kantor
AA3. Jasa. D . 650. PPn
AA3. Jasa. K. 130. PPh 23
AA3. Jasa. K. 7.020. A/P
Yang saya tanyakan bagaiman querynya utk menampilkan semua jurnal AA1 dan AA3 dan utk AA2 tidak ditampilkan karena jutnalnya tidak ada PPh 23 nya
Terima kasih sebelumnya
Best Regards,
Powered by Telkomsel BlackBerry®
------------------------------------
SPAM IS PROHIBITEDYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar