Can anyone help with this...
I have three tables, Users, Books, BookLoans (for a library database.)
I need to print a report on All Users whether they have a book on loan or not. The following gives me anyone that has a book out but not anyone who doesn't.
SELECT BOOKLOANS.Title, UERS.USERID#...