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/