Hello
I have a table
CREATE TABLE acategories {
id integer not null primary key
category string
parent_category integer references acategories.id
)
query:
SELECT
a.id AS 'id',
a.category AS 'Category',
b.category AS 'Parent category'
FROM acategories AS a
LEFT JOIN acategories AS b ON a.parent_category=b.id
everything works ok, but i need to add new field with deepness level
of each row.
Is it possible ?
Thanks
Robert
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
