Re: [belajar-access] Re:

pahami sub query.

select tb_siswa.id_siswa, tb_siswa.nama_siswa,
(select id_pembayaran from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_bln from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_th from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran
from tb_siswa


aksan kurdin



On 4/12/2011 10:00 AM, FAJAR N wrote:

 

Masih blm bisa Pak Aksan, ada warning dari system.

Utk lbh jelas ini sy sertakan contoh tabelnya dan query awalnya. Nah, query akhir yg diinginkan adl dg record yg dlingkari merah.

Terima kasih

Fajar

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___