You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

8 lines
208 B
SQL

\echo JOIN quotes TO categories:
SELECT LEFT(qtext, 50) AS "Quote", description AS "Category"
FROM quote
JOIN quotecategory
ON quote.qid = quotecategory.qid
JOIN category
ON quotecategory.cid = category.cid;