Re: [sqlite] SQL tree and deepness level

Robert Zajda wrote: 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

Re: [sqlite] SQL tree and deepness level

Robert Zajda uttered: 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

[sqlite] SQL tree and deepness level

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