Hierarchical recordsets

2002-01-25 Thread Jon Wahl
doing the subselects - even though they return 5-10 records each. Basically this is a parent record with up to two children recordsets. I think there may be a faster way to do this, but am not quite sure what sql tools are at my disposal. Anyone have an idea of how to approach this??? Jon Wahl

RE: Case for Field Name Alias

2002-01-27 Thread Jon Wahl
I would go for the parameterized solution here - fully flexible routines are a very good thing. Plus it sounds as if your tables will be more normalized - i.e. you won't be including meta-data in your data tables (if I'm interpreting what you're saying correctly). Good luck, Jon > -Origina