Without knowing the table structures and relationship between the entities? I think more detail is in order...

Accomplishing the impossible means only that the boss will add it to your regular duties.
Doug Larson