SBendBuckeye
Programmer
Project involves product promotions. Territory guy reports to the district guy who reports to the regional guy. There are multiple regional guys.Each individual is in the employee file with a manager id which would point to the immediate manager.
How is the best way to write a query so that promotional information could be rolled up from the bottom (eg territory is detail, district is low order group and region is high order group). Do I do a double correlated query to get name and address information for all three layers?
Any ideas would be welcomed! Thanks!
How is the best way to write a query so that promotional information could be rolled up from the bottom (eg territory is detail, district is low order group and region is high order group). Do I do a double correlated query to get name and address information for all three layers?
Any ideas would be welcomed! Thanks!
