JJB Blog

INNER JOIN syntax

21 January 2007 -

It’s too bad that ON (column = column) comes after and not before INNER JOIN table, because if it came before it would make for much cuter code formatting:

[sql]
SELECT DISTINCT $columns
FROM
$this->comments
ON (comment_post_ID = post_id) INNER JOIN
$this->post2cat
ON (category_id = cat_ID) INNER JOIN
$this->categories
WHERE
blog = ‘$blog’ AND
$criteria
[/sql]

No Comments Yet