Hi ,

The strcture of the tables are as follows.
CREATE TABLE STATE_MASTER
( SNAME VARCHAR2(18),
CATEGORY CHAR(1),
TARIFF NUMBER(3,2),
CONSTRAINT CONS_Pk9 PRIMARY KEY(SNAME)
)

CREATE TABLE MOP_ST_APDRP_FUND
( SNAME VARCHAR2(18),
REL_AMT NUMBER(8,2),
REL_DATE DATE,
CONSTRAINT CONS_fk5 FOREIGN KEY (SNAME) REFERENCES STATE_MASTER ON DELETE CASCADE,
CONSTRAINT CONS_Pk11 PRIMARY KEY(SNAME,REL_DATE)
)


CREATE TABLE ST_SEB_APDRP_FUND
( SNAME VARCHAR(18),
T_AMT NUMBER(8,2) NOT NULL,
T_DATE DATE,
CONSTRAINT CONS_fk6 FOREIGN KEY (SNAME) REFERENCES STATE_MASTER ON DELETE CASCADE,
CONSTRAINT CONS_Pk20 PRIMARY KEY (SNAME,T_DATE)
)

I have to extract the information i.e. REL_AMT and T_AMT from MOP_ST_APDRP_FUND and ST_SEB_APDRP_FUND
for all states which is contained in the state_master table.

I made the sql statement as follows:
-------------------------------------------
SELECT ALL STATE_MASTER.SNAME,
sum(MOP_ST_APDRP_FUND.REL_AMT) Released1,
sum(ST_SEB_APDRP_FUND.T_AMT) SEB
FROM STATE_MASTER,
MOP_ST_APDRP_FUND,
ST_SEB_APDRP_FUND
WHERE ((CIRCLE_MASTER.SNAME(+)=STATE_MASTER.SNAME)
AND (MOP_ST_APDRP_FUND.SNAME(+) = STATE_MASTER.SNAME)
AND (ST_SEB_APDRP_FUND.SNAME(+) = STATE_MASTER.SNAME))

But the result is not correct. Please help me all of u for oracle 8i and oracle 9i database.