God Bless You......................

Rabu, 16 November 2011

create database fasilkom use fasilkom create table mahasiswa( nim char(10) primary key, nm_mhs varchar(25), jurusan char(20), tggl_lahir datetime) select*from mahasiswa insert into mahasiswa values('1050201206','Fernando','Sistem Informasi','06-september-1991') insert into mahasiswa values('1050201207','Nia','Teknik informatika','06-aug-1992') insert into mahasiswa values('1050201208','Erma','Sistem Informasi','10-oct-1990') insert into mahasiswa values('1050201209','Weni','Sistem Informasi','12-nov-1993') insert into mahasiswa values('1050201210','Chantry','Teknik informatika','19-oct-1992') insert into mahasiswa values('1050201211','Citra','Teknik informatika','17-aug-1991') insert into mahasiswa values('1050201212','bubu','Teknik informatika','25-oct-1990') insert into mahasiswa values('1050201213','Caca','Sistem Informasi','19-aug-1991') insert into mahasiswa values('1050201214','Faisal','Sistem Informasi','20-oct-1993') insert into mahasiswa values('1050201215','Roma','Teknik informatika','22-aug-1992') create table matakuliah( kode_matkul char(10) primary key, nm_matkul varchar(25), sks int, semester char(10)) select*from matakuliah insert into matakuliah values('mk001','agama',3,'II') insert into matakuliah values('mk002','algoritma',2,'II') insert into matakuliah values('mk003','Basis data',1,'II') insert into matakuliah values('mk004','Bahasa inggris',2,'II') insert into matakuliah values('mk005','Pemrograman',4,'II') insert into matakuliah values('mk006','Bahasa indonesia',2,'II') insert into matakuliah values('mk007','Mtk',3,'II') insert into matakuliah values('mk008','Teknik',2,'I') insert into matakuliah values('mk009','Sistem',4,'I') insert into matakuliah values('mk010','algoritma2',3,'I') select*from mahasiswa left join matakuliah on(mahasiswa.nim=matakuliah.kode_matkul) select*from mahasiswa right join matakuliah on(mahasiswa.nim=matakuliah.kode_matkul) select mahasiswa.nim,mahasiswa.nm_mhs,matakuliah.kode_matkul,matakuliah.nm_matkul from matakuliah cross join mahasiswa select*from mahasiswa right join matakuliah on(mahasiswa.nim=matakuliah.kode_matkul) union select*from mahasiswa left join matakuliah on(mahasiswa.nim=matakuliah.kode_matkul) select*from mahasiswa right join matakuliah on(mahasiswa.nim=matakuliah.kode_matkul) union all select*from mahasiswa left join matakuliah on(mahasiswa.nim=matakulaih.kode_matkul) select*from mahasiswa inner join matakuliah on (mahasiswa.nim=matakuliah.kode_matkul); Tugas SQL

Tidak ada komentar:

Posting Komentar