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?
|
Results 1 to 3 of 3
Thread: SQL statementThreaded View
|
Click Here to Expand Forum to Full Width |