multiple sql queries for one index?

[Joel Nylund]

Hi, Its been hurting my brain all day to try to build 1 query for my  
index (joins upon joins upon joins). Is there a way I can do multiple  
queries to populate the same index? I have one main table that I can  
join everything back via ID, it should be theoretically possible....

If this can be done, can someone point me to an example?
thanks
Joel