Table join

[upaliwije]

Hi

I have 3 following table and want to join them to obtain requried output report

Table 1
POLICY_NO	POLICY_PERIOD	PREMIUM
1	NOV-10-NOV-11	4000
2	DEC-12-DEC-13	5000
3	JAN-14-JAN-15	2000

Table 2
POLICY_NO	POLICY_PERIOD	PAID
1	NOV-10-NOV-11	30000
2	DEC-12-DEC-13	25000
1	NOV-10-NOV-11	12000
2	DEC-12-DEC-13	4000

Table 3
POLICY_NO	POLICY_PERIOD	TYPE	RATE	AMOUNT
1	NOV-10-NOV-11	BASIC	2000
1	NOV-10-NOV-11	NCB	10	-250
1	NOV-10-NOV-11	LOADING		400
2	DEC-12-DEC-13	BASIC	2500
2	DEC-12-DEC-13	NCB	20	-400
2	DEC-12-DEC-13	LOADING	500
3	JAN-14-JAN-15	BASIC	1500

OUTPUT REPORT
POLICY_NO	POLICY_PERIOD	PREMIUM	PAID	BASIC	NCB	RATE	LOADING
1	NOV-10-NOV-11	4000	30000	2000	-250	10	400
12000
2	DEC-12-DEC-13	5000	25000	2500	-400	20	500
4000
3	JAN-14-JAN-15	2000	0	1500

Appreciate very much your  help with a sample report for the above

[upaliwije]

Dear Kavita

Pls send the attachment

[kavita25]

look at my previous post...file is attached..

[upaliwije]

THERE I DONT FIND THE ATTACHMENT PLS REATTACH

[kavita25]

PFA