Home Forums SQL Server 2008 SQL Server Newbies Left Outer Join, Multi Tables, To Populate Checkboxes in Classic ASP Application RE: Left Outer Join, Multi Tables, To Populate Checkboxes in Classic ASP Application

  • Thanks - I wanted to share the solution, thanks to user AlwaysLoadingData on StackExchange:

    SELECT

    KSA.ID as KSA_ID

    ,KSA.KSA_Version

    ,KSA.KSA_Sort_Order_Number

    ,KSA.KSA_Outcome_Number

    ,KSA.KSA_Category as KSA_KSA_Category

    ,KSA.KSA_Category_Sub_Num

    ,KSA.KSA_Category_Sub_Num_Descr

    ,KSA.KSA_Category_Sub_Num_Sub_Alpha

    ,KSA.KSA_Category_Sub_Num_Sub_Alpha_Descr

    ,KSA.KSA_ID as KSA_KSA_ID

    ,KSA.KSA_Descr_Combined as KSA_KSA_Descr_Combined

    ,KSA.LastUpdate

    ,KSA.Date_Created

    ,OutcomesKSA.KSA_ID as OutcomesKSA_KSA_ID

    ,OutcomesKSA.KSA_Value as OutcomesKSA_KSA_Value

    ,OutcomesKSA.ObjOutID

    ,ObjOut.ObjectiveID

    ,ObjOut.OutcomeID

    ,Objectives.ID as Obj_Obj_ID

    FROM

    KSA

    LEFT OUTER JOIN (

    OutcomesKSA

    INNER JOIN ObjOut

    ON OutcomesKSA.ObjOutID = ObjOut.ID

    INNER JOIN Objectives

    ON ObjOut.ObjectiveID = Objectives.ID

    ) ON KSA.ID = OutcomesKSA.KSA_ID

    AND Objectives.ID = 29 --filter

    WHERE

    KSA.KSA_Outcome_Number = '1'

    AND KSA.KSA_Category = 'k'

    ORDER BY KSA.KSA_Sort_Order_Number;