Hi! error with Subquery alias...
help... SELECT *,(SELECT COUNT(id) FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depth FROM articles where (depth < 3) ORDER BY lft Max mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster