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

SQL Left Join Examples

1-) Lists students who have not read books.

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 -
2-) List books that have never been read

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 -
Library Database
Database