2016-03-01 23:36 GMT+06:00 Adam Chlipala <[email protected]>:
> The only issue here is that Ur/Web forces local table names to be
> capitalized.
Thank you very much!
>
>
> On 03/01/2016 11:34 AM, Artyom Shalkhakov wrote:
>
>> 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
>>>
>>
>
> _______________________________________________
> Ur mailing list
> [email protected]
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
>
--
Cheers,
Artyom Shalkhakov
_______________________________________________
Ur mailing list
[email protected]
http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
