I have Two tables, Table A and Table B both of them are child, and both of them are indexed on the Partno and Orderno.
i want to substitute qtys in table B with qtys from table A.
or replace data in Table A Minus (-) Data in Table B

N.B. some records in table A does not have and orderno...i want only records that have Both the Partno and Orderno to be substituted..
Thanks For Help...