Hi guys, this is my first post here. I'm having a lot of trouble writing a fairly simple(i think) query. Here's the situation.
I have a database for an online shopping system that uses Modified Preordered Tree Traversal. basically i need to make a query that does the following:
Select fields named c_left and c_right from a table named categories where the id = a value that will be set by my asp code. For now lets say we need to select c_left and c_right from categories where id=16. then based on the c_left and c_right values i have returned from this i need to select * from categories where c_left > the c_left found from part one of the query and c_right < the c_right from part one.
Any help on this would be greatly appreciated.