select k.id_kamar from kamar k left join pesan p on k.id_kamar = p.id_kamar and p.tgl_masuk <= :end and p.tgl_keluar >= :start where p.id_kamar is null;
salam, - bs On 3/27/07, erfin_gustaman <[EMAIL PROTECTED]> wrote: > > buat skripsi ku nih... mohon bantuaanya kk.. > > relasi tabel untuk pemesanan kamar hotel: > > [tabel tamu] > id_tamu(*) > nama > no_identitas > alamat > telepon > > [tabel pesan] > id_tamu(**) > id_kamar(**) > tgl_masuk > tgl_keluar > tgl_pesan > > [tabel kamar] > id_kamar(*) > tipe_kamar > fasilitas > tarif_kamar > gambar > no_kamar > > bingung kalo pesannya di tanggal yang beda tapi di nomor kamar yang > sama.. > contoh kasus: > a) tamu 1 pesan kamar untuk tgl 17-03-2007 s/d 24-03-2007, dikasih no > kamar 1 > b) tamu 2 pesan kamar untuk tgl 25-03-2007 s/d 31-03-2007, dikasih no > kamar 1 juga > > nah.. > c) tamu 3 pesan kamar untuk tgl 19-03-2007 s/d 31-03-2007, > dikasihkamar yang masih kosong > > querynya gimana ya?? ato relasinya masih salah gitu, harusnya gmn?? > > NB : dbnya pake mysql > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
