Hi Chris,

Firstly thanx for your reply.

I have written below mentioned query that contain six tables:-

LEFT OUTER JOIN on PROD_REQR with three tables (MTP_ISSUE, MTP_TSTK_A & MTP_FGSTK_A ).

EQUAL JOIN on PROD_REQR with two tables (MPC_A & BND_AGNT).

SELECT MPC_A."DOC_DT", MPC_A."DOC_NO", PROD_REQR."doc_no", PROD_REQR."doc_dt", PROD_REQR."a_code", PROD_REQR."p_reqr",

PROD_REQR."p_stk", MTP_ISSUE."issue", bnd_agnt."Frst_bnd", MTP_TSTK_A."RAWQTY", MTP_FGSTK_A."PEND_QTY"

FROM { oj (((("SFNData"."dbo"."MPC_A" MPC_A

INNER JOIN "SFNData"."dbo"."PROD_REQR" PROD_REQR ON MPC_A."DOC_NO" = PROD_REQR."doc_no"

AND MPC_A."DOC_DT" = PROD_REQR."doc_dt") INNER JOIN "SFNData"."dbo"."bnd_agnt" bnd_agnt ON PROD_REQR."a_code" = bnd_agnt."i_code")

LEFT OUTER JOIN "SFNData"."dbo"."MTP_TSTK_A" MTP_TSTK_A ON PROD_REQR."a_code" = MTP_TSTK_A."A_CODE")

LEFT OUTER JOIN "SFNData"."dbo"."MTP_FGSTK_A" MTP_FGSTK_A ON PROD_REQR."a_code" = MTP_FGSTK_A."A_CODE")

LEFT OUTER JOIN "SFNData"."dbo"."MTP_ISSUE" MTP_ISSUE ON PROD_REQR."doc_dt" = MTP_ISSUE."doc_dt" AND PROD_REQR."a_code" = MTP_ISSUE."a_code"}

ORDER BY PROD_REQR."doc_no" ASC

I am using this query to create crystal report but it is hanging my report while running.

Pls tell me all joins are right or wrong or some updation required.

thanx in advance

neel