Dear Experts Please resolve the query i want to create query in this fomat from two different tables.

Query :- Output Parameter is date between 01-01-2014 ~ 07-01-2014

Prod_desc Total TB Total_Prod
A 4 44
B 3 21
C


Prod_desc:- Groupby
Total TB:- Sum TB
Total_Prod:- Sum Prod Qty






1.TB Entry Table:-


Date_of_TB PID Total_TB
01-01-2014 1 2
04-01-2014 2 3
06-01-2014 1 2



1.Production Table:-


Date_of_Prod PID Total_Prod
01-01-2014 1 10
02-01-2014 1 12
03-01-2014 1 15
04-01-2014 2 10
05-01-2014 1 2
06-01-2014 1 5
07-01-2014 2 11



1.Product table


PID Prod_desc
1 A
2 B
3 C

PID is foreign key to both tb entry as well as production

Query :- Output Parameter is date between 01-01-2014 ~ 07-01-2014

Prod_desc Total TB Total_Prod
A 4 44
B 3 21
C


Prod_desc:- Groupby
Total TB:- Sum TB
Total_Prod:- Sum Prod Qty