Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW laporan_pelatihan 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement