need help with write a sql query

[mega-user]

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

[davey23uk]

well what have you come up with so far

[mega-user]

i am arranged thx