Pengantar Bahasa Query:Query Antar Tabel: Difference between revisions
No edit summary |
No edit summary |
||
| Line 26: | Line 26: | ||
__NOINDEX__ | __NOINDEX__ | ||
{{DISPLAYTITLE:Query Antar Tabel}} | {{DISPLAYTITLE:Query Antar Tabel}} | ||
[[Category:Matkul]] | |||
[[Category:SQL]] | |||
[[Category:Pengantar Bahasa Query]] | |||
Revision as of 16:47, 16 November 2022
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