need help with write a sql query
hello i need some help plz...
i have 3 tables : category, productcategory,products
category
int cat id
int parent
varcher title
int lft
int rgt
categortproducts
int prct
int product_id
int cat_id
products
int product_id
varcher product title
the category table is stored as Hierarchical Data.
i need query that get : category id, category rgt , category lft
and show all the products that have cat_id that his rgt and lft is between the rgt and lft that we receive
sorry on my english .. its in improvement level
help me plz
thx
