tengo la siguiente consulta y no me da resultados, me podrian indicar por que.
SELECT "PartCost1"."PartNum",sum("PartCost1"."AvgLaborCos t" + "PartCost1"."AvgBurdenCost" + "PartCost1"."AvgMaterialCost" + "PartCost1"."AvgSubContCost" + "PartCost1"."AvgMtlBurCost") as costo, "Part1"."IUM"
FROM {oj "PUB"."PartCost" "PartCost1" LEFT OUTER JOIN "PUB"."Part" "Part1"
ON ("PartCost1"."Company"="Part1"."Company") AND ("PartCost1"."PartNum"="Part1"."PartNum")} group by PartCost1.PartNum
gracias