i have 2 tables like yarn_fpdt_in and yarn_fpdt_out the yarn_fpdt_in contain barcode,pallet, qty and yarn_fpdt_out contain same like 1st table like following
SELECT * FROM YARN_FPDT_IN;
Barcode Pallet GrossWt Qty
7021 7 1132 900
707179 17 757 599
707183 16 752 599
707195 9 752 599
SELECT * FROM YARN_FPDT_out;
Barcode Pallet GrossWt Qty
7021 1 1132 900...