Okay i have a location table in which i relate each location to a parent location.The top level locations dont have a parent location specified. There can be a number of different levels of locations and all i want to achieve is to output all child locations ordered by each level down ??
Do i need some type of union statement maybe ??
locationid INT PK
locationparent INT FK