Pengantar Bahasa Query:Query Antar Tabel - Revision history

Kangtain: Kangtain moved page Materi/Pengantar Bahasa Query/Query Antar Tabel to Pengantar Bahasa Query:Query Antar Tabel

2022-11-19T16:12:43Z

Kangtain moved page Materi/Pengantar Bahasa Query/Query Antar Tabel to Pengantar Bahasa Query:Query Antar Tabel

← Older revision	Revision as of 23:12, 19 November 2022
(No difference)

Kangtain at 22:40, 18 November 2022

2022-11-18T22:40:59Z

← Older revision		Revision as of 05:40, 19 November 2022
Line 23:		Line 23:
	</syntaxhighlight>		</syntaxhighlight>

	~~[[Category:Materi]]~~
	__NOINDEX__		__NOINDEX__
	~~{{DISPLAYTITLE:Query Antar Tabel}}~~
	[[Category:Matkul]]		[[Category:Matkul]]
	[[Category:SQL]]		[[Category:SQL]]
	[[Category:Pengantar Bahasa Query]]		[[Category:Pengantar Bahasa Query]]
			[[Category:Materi]]

Kangtain at 09:47, 16 November 2022

2022-11-16T09:47:51Z

← Older revision		Revision as of 16:47, 16 November 2022
Line 26:		Line 26:
	__NOINDEX__		__NOINDEX__
	{{DISPLAYTITLE:Query Antar Tabel}}		{{DISPLAYTITLE:Query Antar Tabel}}
			[[Category:Matkul]]
			[[Category:SQL]]
			[[Category:Pengantar Bahasa Query]]

Kangtain at 09:44, 4 September 2022

2022-09-04T09:44:14Z

← Older revision		Revision as of 16:44, 4 September 2022
Line 1:		Line 1:
	select * from anggota		<syntaxhighlight lang="sql">
			select * from anggota
			</syntaxhighlight>

	select * from buku		<syntaxhighlight lang="sql">
			select * from buku
			</syntaxhighlight>

	select * from pinjam		<syntaxhighlight lang="sql">
			select * from pinjam
			</syntaxhighlight>

	SELECT Pinjam.NoNota, Pinjam.TglPinjam, Pinjam.TglKembali, Pinjam.NoAgt, Anggota.NoAgt, Anggota.Kelas, Pinjam.KodeBk, Buku.JudulBk FROM Anggota, Buku, Pinjam WHERE Pinjam.NoAgt=Anggota.NoAgt and Pinjam.KodeBk=Buku.KodeBk ORDER BY pinjam.NoNota		<syntaxhighlight lang="sql">
			SELECT Pinjam.NoNota, Pinjam.TglPinjam, Pinjam.TglKembali, Pinjam.NoAgt, Anggota.NoAgt, Anggota.Kelas, Pinjam.KodeBk, Buku.JudulBk FROM Anggota, Buku, Pinjam WHERE Pinjam.NoAgt=Anggota.NoAgt and Pinjam.KodeBk=Buku.KodeBk ORDER BY pinjam.NoNota
			</syntaxhighlight>

	SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND C.KodeBk='B0001' ORDER BY C.NoNota		<syntaxhighlight lang="sql">
			SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND C.KodeBk='B0001' ORDER BY C.NoNota
			</syntaxhighlight>

	SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND A.Kelas='KBS041' ORDER BY C.NoNota		<syntaxhighlight lang="sql">
			SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND A.Kelas='KBS041' ORDER BY C.NoNota
			</syntaxhighlight>

	[[Category:Materi]]		[[Category:Materi]]
	__NOINDEX__		__NOINDEX__
			{{DISPLAYTITLE:Query Antar Tabel}}

Kangtain: Kangtain moved page Query Antar Tabel to Materi/Pengantar Bahasa Query/Query Antar Tabel

2022-09-04T09:37:58Z

Kangtain moved page Query Antar Tabel to Materi/Pengantar Bahasa Query/Query Antar Tabel

← Older revision	Revision as of 16:37, 4 September 2022
(No difference)

Kangtain: Created page with " select * from anggota select * from buku select * from pinjam SELECT Pinjam.NoNota, Pinjam.TglPinjam, Pinjam.TglKembali, Pinjam.NoAgt, Anggota.NoAgt, Anggota.Kelas, Pinjam.KodeBk, Buku.JudulBk FROM Anggota, Buku, Pinjam WHERE Pinjam.NoAgt=Anggota.NoAgt and Pinjam.KodeBk=Buku.KodeBk ORDER BY pinjam.NoNota SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt a..."

2022-04-13T02:57:53Z

Created page with " select * from anggota select * from buku select * from pinjam SELECT Pinjam.NoNota, Pinjam.TglPinjam, Pinjam.TglKembali, Pinjam.NoAgt, Anggota.NoAgt, Anggota.Kelas, Pinjam.KodeBk, Buku.JudulBk FROM Anggota, Buku, Pinjam WHERE Pinjam.NoAgt=Anggota.NoAgt and Pinjam.KodeBk=Buku.KodeBk ORDER BY pinjam.NoNota SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt a..."

New page

select * from anggota

select * from buku

select * from pinjam

SELECT Pinjam.NoNota, Pinjam.TglPinjam, Pinjam.TglKembali, Pinjam.NoAgt, Anggota.NoAgt, Anggota.Kelas, Pinjam.KodeBk, Buku.JudulBk FROM Anggota, Buku, Pinjam WHERE Pinjam.NoAgt=Anggota.NoAgt and Pinjam.KodeBk=Buku.KodeBk ORDER BY pinjam.NoNota

SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND C.KodeBk='B0001' ORDER BY C.NoNota

SELECT C.NoNota, C.TglPinjam, C.TglKembali, C.NoAgt, A.NoAgt, A.Kelas, C.KodeBk, B.JudulBk, B.Pengarang FROM Anggota A, Buku B, Pinjam C WHERE C.NoAgt=A.NoAgt and C.KodeBk=B.KodeBk AND C.KodeBk=B.KodeBk AND A.Kelas='KBS041' ORDER BY C.NoNota

[[Category:Materi]]
__NOINDEX__