Access Kode

insert into mahasiswa values (:nim,:nama,:jurusan,:alamat)
update manufaktur set NAMA=’Amey’  where  NO_MANU=1
SELECT * from mahasiswa order by nim
SELECT * from manufaktur where no_manu=1
delete from FRS where semester=:semester
Update MHS set nama=:amey where nama=Imoet

mahasiswa
insert into mahasiswa values (:nim,:nama,:alamat,kd_jurusan)
delete from mahasiswa where nim=:nim
update mahasiswa set nama=:nama, alamat=:alamat, where nim=:nim
SELECT * from mahasiswa

dosen
insert into mahasiswa  values (:nim,:nama,:jurusan,:alamat)
delete from mahasiswa where nim=:nim
update mahasiswa set nim=:nim where  nama=:nama
SELECT * from dosen

jurusan
insert into jurusan values (:kd_jurusan,:nama)
delete from jurusan  where :kd_jurusan
update jurusan set nama=:nama where kd_jurusan=:kd_jurusan
SELECT * from jurusanx

khs
insert into mahasiswa values (:nim,:nama,:jurusan,:alamat)
delete from mahasiswa where nim=:nim
update mahasiswa set nim=:nim where  nama=:nama
SELECT * from mahasiswa order by nim

Select * from MHS inner join FRS on MHS_nim=FRM_nim Where semester=2


NB: Inner Join Bisa Diganti:
1. Left join
2. Right join
3. Cross join

SELECT penginap.nama, data_penginapan.Total_Biaya_Menginap
FROM penginap INNER JOIN (Kamar INNER JOIN Data_Penginapan ON Kamar.ID=Data_Penginapan.ID_Kamar) ON Penginap.ID=data_penginapan.ID_Penginap
WHERE penginap.nama="Umar Fadli";