Results 1 to 7 of 7
Thread: Join and null values??
Jan 21, 2011, 14:44 #1
- Join Date
- Feb 2005
- was rainy Oregon now sunny Florida
- 2 Post(s)
- 0 Thread(s)
Join and null values??
Hi all, hope someone can help with this.
I have a join statement.
SELECT booksoutdoors.title , booksoutdoors.author , bookscooking.title , bookscooking.author FROM booksoutdoors, bookscooking WHERE bookscooking.author = 'Loren' AND booksoutdoors.author = 'Loren'
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.
LorenWhat I lack in acuracy I make up for in misteaks