I have two tables one with production data the other is scrap data. The tables look pretty much identical, though i cannot make my query work.Production table is like thisPrDate, PrUser, PrMachine, PrDept, PrItemCode, PrQuantity