>Any help would be greatly appreciated.

Can you give an example of of which fields in which tables you need to pull out and how the tables relate to each other? Something like this is always easier to visualize with sample data structures.