anda sesuaikan saja field2 yang dibutuhkan.
SELECT Table1.ID, Table1.NO_JURNAL, Table1.TANGGAL, Table1.KET, Table1.D_K, Table1.NOMINAL, Table1.NO_PROACC, Table1.DESC, Table1.NO_CASH, Table1.NM_CASH, Table1.PERIODE, Table1.NO_PROJECT
FROM Table1
WHERE (((Table1.NO_JURNAL) In (select distinct no_jurnal from table1 where ket like 'PPh*')));
On 9/26/2013 5:37 PM, Jhony Xl wrote:
SELECT Table1.ID, Table1.NO_JURNAL, Table1.TANGGAL, Table1.KET, Table1.D_K, Table1.NOMINAL, Table1.NO_PROACC, Table1.DESC, Table1.NO_CASH, Table1.NM_CASH, Table1.PERIODE, Table1.NO_PROJECT
FROM Table1
WHERE (((Table1.NO_JURNAL) In (select distinct no_jurnal from table1 where ket like 'PPh*')));
On 9/26/2013 5:37 PM, Jhony Xl wrote:
����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
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/
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar