Adding Categories....table join?

[eluser]Armchair Samurai[/eluser]
The x and y are aliases... I mainly use them because I'm lazy and it takes less typing, especially with more complex joins. For example, these two queries are the same:

Code:

SELECT articles.*
FROM articles
JOIN articlecategories ON articles.ID = articlecategories.articleID
JOIN categories ON articlecategories.CategoryID = categories.ID
WHERE categories.name = 'foo'

// Same query as above, but fewer keystrokes.

SELECT x.*
FROM articles AS x
JOIN articlecategories AS y ON x.ID = y.articleID
JOIN categories AS z ON y.CategoryID = z.ID
WHERE z.name = 'foo'