Oct 25, 2011 09:23 AM|Mamba Dai - MSFT|LINK
Your information indicates you need to redesign your structure of tables and use join query, and you aslo mentioned how to redesign the tables. Therefore, the key point how to use join query to retrieve the records, please check this reference about join
By the way, if you can post your problem to this:
You will recieve more professional and exact idea for your issue.