Wiki

Pengantar Bahasa Query:Query Antar Tabel: Difference between revisions

← Older editNewer edit →
Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
No edit summary
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}}
Retrieved from "https://kangtain.com/wiki/index.php/Pengantar_Bahasa_Query:Query_Antar_Tabel"