Question: Consider the tables; Library User (first name, last name, card number) and Library Book (title, author, bookID, card number). Card number is the unique library

Consider the tables; Library User (first name, last name, card number) and Library Book (title, author, bookID, card number). Card number is the unique library card number for a user and is used in the Library Book table to tell who has checked out that book. If a book is not checked out, this value is NULL. Page 4 of 6 Write a query that selects all the user last names, card numbers and titles of books they have checked out include a user even if they have no books checked out. Users with more than one book checked out will have a record returned for each book. HINT: Can be solved by using left outer join
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
