I’ve got one table - called ‘posts’ which has the price and quality of a book someone would be selling, as well as an entry called ‘book’ - which is the reference to the id of a row in another table (‘books’), which contains the title, author, edition, etc…
I’d like to, within a single query, select the price (which would be from ‘posts’ and the title, author, edition, etc. (from ‘books’) in one statement).
So, something like this (except I’m getting errors):
SELECT (posts.price, posts.id FROM posts), (books.title, books.price WHERE id = posts.book)
Thanks 
