[Attachment(s) from Jhony Xl included below]
Jhony Syarif
misalkan tabelnya namanya tabel1,
lakukan filter dengan sub query
select *
from tabel1
where voucher in (select distinct voucher from tabel1 where jurnal='PPh 23')
aksan kurdin
On 9/26/2013 11:03 AM, jhony.excel@yahoo.co.id wrote:
> 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
>
>
>
------------------------------------
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/
berikut saya lampirkan filenya, bisa dicontoh di file ini pak
Terima kasih
Sincerely yours,
Jhony Syarif
Dari: aksan kurdin <aksan.kurdin@gmail.com>
Kepada: belajar-access@yahoogroups.com
Dikirim: Kamis, 26 September 2013 11:31
Judul: Re: [belajar-access] Query Menampilkan semua Voucher yang ada pph 23 nya
Kepada: belajar-access@yahoogroups.com
Dikirim: Kamis, 26 September 2013 11:31
Judul: Re: [belajar-access] Query Menampilkan semua Voucher yang ada pph 23 nya
misalkan tabelnya namanya tabel1,
lakukan filter dengan sub query
select *
from tabel1
where voucher in (select distinct voucher from tabel1 where jurnal='PPh 23')
aksan kurdin
On 9/26/2013 11:03 AM, jhony.excel@yahoo.co.id wrote:
> 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
>
>
>
------------------------------------
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/
__._,_.___
Attachment(s) from Jhony Xl
1 of 1 File(s)
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar