Hi all, hope someone can help with this.
I have a join statement.
Code:
SELECT booksoutdoors.title
, booksoutdoors.author
, bookscooking.title
, bookscooking.author

FROM booksoutdoors, bookscooking 
WHERE bookscooking.author = 'Loren'
AND booksoutdoors.author = 'Loren'
This works fine if Loren had a book about the outdoors and cooking.
I am trying to get this to work if the author only had a cookbook.

I'm thinking of a CASE situation but since the author is not in books.cooking I don't get a NULL so this is where I am totally lost.

Any advice or help is greatly appreciated.
Thanks
Loren