Home Forums SQL Server 2005 T-SQL (SS2K5) How to join four tables using left outer join RE: How to join four tables using left outer join

  • October 8, 2012 at 6:36 am

    #1546689

    just formatted for readability:

    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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!