I'm assuming your tables are related in some way, e.g.
fields: id, firstName, lastName
fields: id, title, authorId
Then to return the titles and author names for all books:
SELECT b.title, a.firstName, a.lastName
FROM authors a, books b
WHERE b.authorId = a.id
You can also do this with JOIN, but the above is perhaps more obvious.