Hi all, hope someone can help with this.
I have a join statement.
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.