Man ersetzt jeweils FORM durch FROM:
SELECT articles.artikel_id, articles.headline, articles.text, categories.title FROM articles INNER JOIN categories ON articles.category_id = categories.category_id
SELECT articles.artikel_id, articles.headline, articles.text, categories.title FROM articles, categories WHERE articles.category_id = categories.category_id
viele Grüße
Axel