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:maxim.bondaruk@xxxxxxxxx
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:maxim.bondaruk@xxxxxxxxx