I want to preload some tables into the jcs cache, and doing so ok for most by just finding all.

However, I'm not finding the right way to do this on a one-to-many pair of tables.

If I load the many side table first, then the one, each of the results in the one side does a query for the set inside, which I am trying to avoid. I realize it will get just record results and hit that many side cache, but I am trying to avoid all the individual db calls.

rick

never mind! I forgot about the fetch syntax, now it is just swell!