想把两张表做个比对,表a里有表b里没有的数据在表a里标注出来,要怎么做啊?
表a
A | 32,955.13 | B | 27,138.69 | C | 15,276.89 | F | 110,369.26 | D | 12,226.79 | E | 10,137.02 | H | 104,577.37 | J | 16,425.50 | U | 17,716.29 | D | 182,773.50 | S | 15,702.47 | J | 12,937.92 | O | 28,098.00 | PO | 30,066.00 | ; | 13,010.51 | DC | 10,062.19 | W | 35,080.33 | X | 26,641.89 | J | 76,123.28 | O | 13,350.29 | PO | 16,303.90 | S | 30,896.25 | W | 123,576.37 | C | 14,197.30 | Y | 178,419.12 | B | 10,000.00 | 5T | 37,804.61 | J | 10,032.92 | V | 10,117.92 | 表b
U | 35,034.75 | M | 13,563.45 | D | 10,122.15 | 7 | 15,171.06 | T | 12,960.90 | IO | 14,590.71 | O0 | 26,159.99 | L; | 30,010.37 | F | 1,821,253.17 | D | 85,314.30 | E | 334,167.98 | H | 50,088.87 | J | 20,418.37 | U | 99,669.51 | D | 25,837.04 | S | 24,885.97 | J | 22,093.15 | O | 56,606.85 | PO | 16,615.16 |
本帖最后由 心正意诚身修 于 2015-3-24 15:36 编辑
做出来了.不过运算量太大了...應樓主要求,刪除了原來的附件.隨便傳了一下.附件是錯誤的.
|