\echo INNER JOIN quote TO author:
SELECT LEFT(qtext, 58) AS "Quote", fname || ' ' || lname AS "Author"
FROM quote
INNER JOIN author
ON quote.aid = author.aid;