Why not create yourself a special Data Query Object which maps to all the fields that you need to retrieve from your query of multiple tables.
When you retrieve a row, this object can map the parts of it to the individual objects you use for the separate tables.
I tend to use these to improve efficiency, where you can retrieve from several tables in one shot rather than having to make several separate queries.
Just a thought...
When you retrieve a row, this object can map the parts of it to the individual objects you use for the separate tables.
I tend to use these to improve efficiency, where you can retrieve from several tables in one shot rather than having to make several separate queries.
Just a thought...