SELECT   TOP ( 100 ) PERCENT dbo.tbldrawings.draw_drawingid, 
                             Isnull(tblmanhourspipe.manhourspipe,0)           AS manhourspipenum, 
                             Isnull(tblmanhourswelds.manhourswelds,0)         AS manhoursweldsnum, 
                             Isnull(tblmanhoursboltups.manhoursboltups,0)     AS manhoursboltupsnum, 
                             Isnull(tblmanhoursvalve.manhoursvalve,0)         AS manhoursvalvenum, 
                             Isnull(tblmanhoursthreaded.manhoursthreaded,0)   AS manhoursthreadednum, 
                             Isnull(tblmanhoursattach.earnedmanhoursattach,0) AS earnedmanhoursattachnum 
FROM     dbo.tbldrawings 
         LEFT OUTER JOIN (SELECT tbldrawingspools_3.dspool_drawingid, 
                                 vwdrawingspoolhistorysum_3.sum_budgetmanhours AS manhoursthreaded 
                          FROM   dbo.tbldrawingspools AS tbldrawingspools_3 
                                 INNER JOIN dbo.tblspools AS tblspools_3 
                                   ON tbldrawingspools_3.dspool_spoolid = tblspools_3.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories AS tblspoolcategories_3 
                                   ON tblspools_3.spool_spoolcategoryid = tblspoolcategories_3.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum AS vwdrawingspoolhistorysum_3 
                                   ON tbldrawingspools_3.dspool_drawingspoolid = vwdrawingspoolhistorysum_3.dshi_drawingspoolid 
                          WHERE  (tblspoolcategories_3.spoolc_spoolcategoryid = 7)) AS tblmanhoursthreaded 
           ON dbo.tbldrawings.draw_drawingid = tblmanhoursthreaded.dspool_drawingid 
         LEFT OUTER JOIN (SELECT tbldrawingspools_4.dspool_drawingid, 
                                 vwdrawingspoolhistorysum_4.sum_budgetmanhours AS manhoursvalve 
                          FROM   dbo.tbldrawingspools AS tbldrawingspools_4 
                                 INNER JOIN dbo.tblspools AS tblspools_4 
                                   ON tbldrawingspools_4.dspool_spoolid = tblspools_4.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories AS tblspoolcategories_4 
                                   ON tblspools_4.spool_spoolcategoryid = tblspoolcategories_4.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum AS vwdrawingspoolhistorysum_4 
                                   ON tbldrawingspools_4.dspool_drawingspoolid = vwdrawingspoolhistorysum_4.dshi_drawingspoolid 
                          WHERE  (tblspoolcategories_4.spoolc_spoolcategoryid = 6)) AS tblmanhoursvalve 
           ON dbo.tbldrawings.draw_drawingid = tblmanhoursvalve.dspool_drawingid 
         LEFT OUTER JOIN (SELECT tbldrawingspools_6.dspool_drawingid, 
                                 vwdrawingspoolhistorysum_6.sum_budgetmanhours AS manhourswelds 
                          FROM   dbo.tbldrawingspools AS tbldrawingspools_6 
                                 INNER JOIN dbo.tblspools AS tblspools_6 
                                   ON tbldrawingspools_6.dspool_spoolid = tblspools_6.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories AS tblspoolcategories_6 
                                   ON tblspools_6.spool_spoolcategoryid = tblspoolcategories_6.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum AS vwdrawingspoolhistorysum_6 
                                   ON tbldrawingspools_6.dspool_drawingspoolid = vwdrawingspoolhistorysum_6.dshi_drawingspoolid 
                          WHERE  (tblspoolcategories_6.spoolc_spoolcategoryid = 2) 
                                  OR (tblspoolcategories_6.spoolc_spoolcategoryid = 3) 
                                  OR (tblspoolcategories_6.spoolc_spoolcategoryid = 4)) AS tblmanhourswelds 
           ON dbo.tbldrawings.draw_drawingid = tblmanhourswelds.dspool_drawingid 
         LEFT OUTER JOIN (SELECT tbldrawingspools_5.dspool_drawingid, 
                                 vwdrawingspoolhistorysum_5.sum_budgetmanhours AS manhoursboltups 
                          FROM   dbo.tbldrawingspools AS tbldrawingspools_5 
                                 INNER JOIN dbo.tblspools AS tblspools_5 
                                   ON tbldrawingspools_5.dspool_spoolid = tblspools_5.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories AS tblspoolcategories_5 
                                   ON tblspools_5.spool_spoolcategoryid = tblspoolcategories_5.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum AS vwdrawingspoolhistorysum_5 
                                   ON tbldrawingspools_5.dspool_drawingspoolid = vwdrawingspoolhistorysum_5.dshi_drawingspoolid 
                          WHERE  (tblspoolcategories_5.spoolc_spoolcategoryid = 6)) AS tblmanhoursboltups 
           ON dbo.tbldrawings.draw_drawingid = tblmanhoursboltups.dspool_drawingid 
         LEFT OUTER JOIN (SELECT dbo.tbldrawingspools.dspool_drawingid, 
                                 dbo.vwdrawingspoolhistorysum.sum_budgetmanhours AS manhourspipe 
                          FROM   dbo.tbldrawingspools 
                                 INNER JOIN dbo.tblspools 
                                   ON dbo.tbldrawingspools.dspool_spoolid = dbo.tblspools.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories 
                                   ON dbo.tblspools.spool_spoolcategoryid = dbo.tblspoolcategories.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum 
                                   ON dbo.tbldrawingspools.dspool_drawingspoolid = dbo.vwdrawingspoolhistorysum.dshi_drawingspoolid 
                          WHERE  (dbo.tblspoolcategories.spoolc_spoolcategoryid = 1)) AS tblmanhourspipe 
           ON dbo.tbldrawings.draw_drawingid = tblmanhourspipe.dspool_drawingid 
         LEFT OUTER JOIN (SELECT tbldrawingspools_2.dspool_drawingid, 
                                 vwdrawingspoolhistorysum_2.sum_earnedbudgetmanhours AS earnedmanhoursattach 
                          FROM   dbo.tbldrawingspools AS tbldrawingspools_2 
                                 INNER JOIN dbo.tblspools AS tblspools_2 
                                   ON tbldrawingspools_2.dspool_spoolid = tblspools_2.spool_spoolid 
                                 INNER JOIN dbo.tblspoolcategories AS tblspoolcategories_2 
                                   ON tblspools_2.spool_spoolcategoryid = tblspoolcategories_2.spoolc_spoolcategoryid 
                                 INNER JOIN dbo.vwdrawingspoolhistorysum AS vwdrawingspoolhistorysum_2 
                                   ON tbldrawingspools_2.dspool_drawingspoolid = vwdrawingspoolhistorysum_2.dshi_drawingspoolid 
                          WHERE  (tblspoolcategories_2.spoolc_spoolcategoryid = 8)) AS tblmanhoursattach 
           ON dbo.tbldrawings.draw_drawingid = tblmanhoursattach.dspool_drawingid 
ORDER BY dbo.tbldrawings.draw_drawingid