Training1, Sql Server

Training1

CREATE TABLE tblMahasiswa
    ([NIM] varchar(13), [Nama] varchar(57))
;
CREATE TABLE tblMataKuliah
    ([Id] varchar(13), [MataKuliah] varchar(57))
;
CREATE TABLE tblMahasiswaMatakuliah
    ([NIM] varchar(13), [MataKuliahId] varchar(13))
;

INSERT INTO tblMahasiswa
    ([NIM], [Nama])
VALUES
    ('003','Agus'),
    ('001','Budi'),
    ('002','Iwan')
;

INSERT INTO tblMataKuliah
    ([Id], [MataKuliah])
VALUES
    ('013','Kalkulus'),
    ('012','Algorithma'),
    ('011','Aljabar Linear')
;

INSERT INTO tblMahasiswaMatakuliah
    ([NIM], [MataKuliahId])
VALUES
    ('001','011'),
    ('001','012'),
    ('001','013'),
    ('002','012'),
    ('002','013'),
    ('003','013')
;

--SELECT * FROM tblMahasiswa 
--SELECT * FROM tblMahasiswaMatakuliah
--SELECT * FROM tblMatakuliah

SELECT * FROM tblMahasiswa 
WHERE Nama='Agus'
ORDER BY NIM
--LEFT JOIN tblMahasiswaMatakuliah ON tblMahasiswa.NIM=tblMahasiswaMatakuliah.NIM
--LEFT JOIN tblMatakuliah ON tblMatakuliah.Id=tblMahasiswaMatakuliah.MataKuliahId


run \| edit \| history \| help	0