SELECT table1.ProjectWorkId,
       table1.Enterprise,
       table1.Platform,
       table1.LOB,
       table1.BusinessUnit,
       table1.WorkTransitCRH,
       table1.WorkTransitCRHNumber,
       table1.WorkTransitCRHName,
       table1.ProjectPlanningCode,
       table1.ProjectName,
       table1.SchedulePlanningCode,
       table1.ScheduleTaskName,
       table1.ActualExpenditureID,
       table1.ActualExpenditureDescription,
       table1.PlannedExpenditureID,
       table1.PlannedExpenditureDescription,
       table1.ActualExternalID,
       table1.ActualExpenditureType,
       table1.ActualCurrencyType,
       table1.ActualAmount,
       table1.ActualDate,
       table1.ActualTransit,
       table1.ActualTransitNumber,
       table1.ActualTransitName,
       table1.ActualGlobalResourcingSupplier,
       table1.ActualShoreType,
       table1.ActualNotes,
       table1.LastUpdateDate,
       table1.LastUpdateById,
       table1.LastUpdateByName,
       table1.ChangeHistoryFlag,
       table1.ChangeHistoryCount,
       table2.PlannedAmount,
       table3.ProjectOwner,
       table3.ManagerLevel5
FROM DWX50_Rpt..table1 /* in MS SQL, I believe you can do '..' instead of '.dbo.' */
    JOIN table2
        ON table1.ProjectWorkId = table2.ProjectWorkID
    JOIN table3
        ON table1.ProjectWorkId = table3.ProjectWorkID
WHERE table1.WorkTransitCRHNumber in (1363, 6196, 6348, 7308, 9438, 11635); /* you can use a set instead of a single value in this case */