The Queries in this page solved at the library database. It is a sample database generated by randomly records. You can download it from the link. You will see more than 500 examples in the future. You can filter from the search panel above by selecting sql statements. I hope you will like it
Solution 1)
Select students.* from students
left join borrows on students.studentId = borrows.studentId
where borrowsno is null
Solution 2)
Select * from students
where studentId not in
(Select studentId from borrows)
ETİKETLER
Select - Where - Sub Query - Çoklu Tablo - Left Join -Solution 1)
Select books.* from books
left join borrows on books.bookId = borrows.bookId
where borrowsno is null
Solution 2)
Select * from books
where bookId not in
(Select bookId from borrows)
ETİKETLER
Select - Where - Sub Query - Çoklu Tablo - Left Join -