Thanks as per the solution I pulled the SQL from my reporting software as that's how I ended up designing it
SELECT "Material_Trans"."Material", "Material_Req"."Material", "Material_Req"."Material_Req", "Material_Trans"."Tran_Type", "Material_Trans"."Material_Req", "Material_Trans"."Location_ID", "Material_Trans"."Material_Trans_Date", "Material_Trans"."Quantity", "Material_Trans"."Unit_Cost", "Material_Trans"."Lot", "Material_Req"."Job", "Material_Trans"."Vendor"
FROM "PRODUCTION"."dbo"."Material_Trans" "Material_Trans" LEFT OUTER JOIN "PRODUCTION"."dbo"."Material_Req" "Material_Req" ON "Material_Trans"."Material_Req"="Material_Req"."Material_Req"
WHERE ("Material_Trans"."Tran_Type"='Adjustment' OR "Material_Trans"."Tran_Type"='Issue' OR "Material_Trans"."Tran_Type"='LocTfr' OR "Material_Trans"."Tran_Type"='Transfer')