i m having 3 tables 1 main and 2 detail tables
there is common field in all three is rcpt_no
from main table i wnated to have rcpt_no and amt
and in detail table there can be more than one record af same rcpt_no i wnted to have the sum of amt of (table2) and table3 matching to the main talbe1 rcpt_no
if i link only one table it shows properly but if i join 2 talbe the totl are getting wrong i have tried by tking runing totl please guide me
Yousuf