, A table for order detail, B table for acceptance of the subsidiary, is left to pass before the join with B table to update A table, but there was A situation, existing some acceptance details are not order, this can make some of the B table data is unable to update to A table, if use A table to update the B table, part of A table data is overdue orders, can also cause A part of the data can't update A table to table B, bosses, please help to see how to deal with this problem?