Hello

could you please provide some sample data for each of your tables and also what results you are expecting, based on the sample data, once they are all put into one table?

Phil suggested reading a link in how to provide this in his post above.

If you are still unclear...pls post back, I am sure we can help, but some idea of the data that you can see would help us help you.

hope this helps....look forward to your reply.