Why does this code not work?: (If I remove book_info and author in the 'where' clause, it still doesn't work).
SELECT title, last_name
FROM book_info NATURAL JOIN book_author natural join author
WHERE book_info.title = ‘Uncle Samsonite’ AND author.last_name = ‘Shakespeare’;
The error message I get is:
ERROR: syntax error at or near "Samsonite’"
LINE 3: WHERE book_info.title = ‘Uncle Samsonite’ AND author.last_na...
Without the 'where' clause it looks like this:
