create table kamar(tipekamar text (10) not null primary key,nmkamar text (15),harga currency);
insert into kamar values("deluxe","anggrek","120000");
insert into kamar values("vip","melati","100000");
create table karyawan(nok text(4) not null primary key,nama text (10) ,alamat text (15),shift text (5));
insert into karyawan values("101","asep","bogor","pagi");
insert into karyawan values("102","udin","bandung","malam");
create table billroom(billnumber text (10) ,tanggal date,tipekamar text (10),nok text (4),bnykkamar number);
insert into billroom values("ab01","09/04/2011","deluxe","101","1");
insert into billroom values("ab02","10/04/2011","vip","102","1");
2 table
SELECT billroom.billnumber, billroom.tanggal, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar;
3 table
SELECT billroom.billnumber, billroom.tanggal, karyawan.nama, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM (kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar) INNER JOIN karyawan ON karyawan.nok=billroom.nok;
insert into kamar values("deluxe","anggrek","120000");
insert into kamar values("vip","melati","100000");
create table karyawan(nok text(4) not null primary key,nama text (10) ,alamat text (15),shift text (5));
insert into karyawan values("101","asep","bogor","pagi");
insert into karyawan values("102","udin","bandung","malam");
create table billroom(billnumber text (10) ,tanggal date,tipekamar text (10),nok text (4),bnykkamar number);
insert into billroom values("ab01","09/04/2011","deluxe","101","1");
insert into billroom values("ab02","10/04/2011","vip","102","1");
2 table
SELECT billroom.billnumber, billroom.tanggal, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar;
3 table
SELECT billroom.billnumber, billroom.tanggal, karyawan.nama, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM (kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar) INNER JOIN karyawan ON karyawan.nok=billroom.nok;
