[Ur] SQL: renaming tables

[Artyom Shalkhakov]

Dear all,

How to write a query that involves renaming of table vars?

For instance, I'd like to write something along the lines of:

> SELECT
>     category.CategoryID,
>     category.Title,
>     category.Slug,
>     category.ImageID,
>     category.ParentCategoryID,
>     0 AS ProductCount
> FROM category
> INNER JOIN product_of_category AS pc ON
> category.CategoryID = pc.CategoryID
> WHERE pc.ProductID = {[product_id]}

And I get:

> syntax error: deleting  SYMBOL AS

-- 
Cheers,
Artyom Shalkhakov