Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW pendaftaran_bulan_ini2 AS
- SELECT nama_peserta,email,telepon,nama_pelatihan,tanggal_mulai,tanggal_selesai,tanggal_pendaftaran,status
- FROM pendaftaran JOIN peserta
- ON pendaftaran.id_peserta = peserta.id_peserta
- JOIN pelatihan
- ON pelatihan.id_pelatihan = pendaftaran.id_pelatihan
- WHERE TO_CHAR(pendaftaran.tanggal_pendaftaran,'Month') = TO_CHAR(SYSDATE,'Month');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement