Select query for subcategories

[Senna]

Hi all

Have a category and a item table like this:

CREATE TABLE #Category
(
ca_id INT PRIMARY KEY,
ca_parentid INT,
ca_name VARCHAR
)

CREATE TABLE #Item
(
it_id INT PRIMARY KEY,
it_ca_id INT,
it_name VARCHAR
)

If I now have a main category named Car then it can have
a subcategory named GM which can have a subcategory named
Saab and drilling down.
Now I need a query that can select every item from a
specific main category id and all its subcategories.

Any ideas?

Best regards / Senna

 

[Allen Browne]

To drill down through self-joined subcategories, see:
Bill Of Materials
at:
http://www.mvps.org/access/modules/mdl0027.htm

 

[Senna]

Hi Allen

Thanks for the link, will try to make sense of it.

Best regards / Senna