Hi, I am ready to help you to write the needed T-sql query, I see in your case the better is using three loops to read from the three tables.
I have experience in VB.net, MS SQL server, asp.net and crystal reports more than 13 years.
Other skills:
Access vba, Excel vba, C#, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers.
Best Regards.
Khaled Alflah