Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
how can i mix both querys
Recursion and cte
#Temp table Collation fixed
IOU
CorreçãoDeErros - UPDATE, DELETE e ALTER TABLE
trigger
Crea, confirma y despliega tablas
Demo
SQL Server - Multiple Holidays Model
Demo