I'm helping my buddy out with his mySQL final project and i've hit a couple of snags... i'll be posting in here as i run into each problem. First problem i've come accross... I need to select all the users and then list if they've checked out a book from the fictitious library. I ran this query: Code: SELECT CONCAT(PATRONS.fName, ' ', PATRONS.lName) AS 'Name', PUBLICATIONS.title, CHECKEDOUT.dueBack FROM PATRONS INNER JOIN PUBLICATIONS ON PATRONS.checkoutID = PUBLICATIONS.publicationID INNER JOIN CHECKEDOUT ON PATRONS.patronID = CHECKEDOUT.patronID ORDER BY PATRONS.fName; but it only returns those users who are listed in the checkedout table. How do i list all entries in the patrons table and not just those in the checkedout table as well?