i have two table
WorkOrder(WorkOrderNO, TotalQty)
Rework(WorkOrderNo, DefectQty, RepairQty, ScrapQty)

How can join this two table and show out the workorderno, the sum of defectqty, repairqty and totalqty?