Hello - I am trying to find an efficient way to get a distinct list of missing numbers from two different tables. I would like to return values that are missing comparing table 1 to table 2 and table 2 compared to table 1. In the following comparison Order # 338790 is missing but I don't know what formula I can use to compare just the numeric value. Thank you Forum members who have suggestions.
Table 1 -
Table 2 - Ln Ref/TMS Order #
Table 1 -
| Merchant | Date | Ancillary |
| TEST | 03-07-2022 22:09:23 | sys_tracking_id=339061 Buyer=One |
| TEST | 03-08-2022 09:22:44 | sys_tracking_id=339176 Buyer=Two |
Table 2 - Ln Ref/TMS Order #
| Journal/Transaction Date | Posted Date | Status | Source | Line # | Speedtype | Account | Business Unit | Fund | DeptID | Program | Project | Class | Ln Ref/TMS Order# | Amount |
3/8/2022 | 3/8/2022 | Posted | MKT | 22 | XX64143000 | 999999 | TEST | 0000 | C1111111 | 0 | 00 | 0 | TMS339061 | -4.520 |
3/8/2022 | 3/8/2022 | Posted | MKT | 37 | XX64143000 | 999999 | TEST | 0000 | C1111111 | 0 | 00 | 0 | TMS339176 | -9.200 |
3/8/2022 | 3/8/2022 | Posted | MAE | 3 | XX64143000 | 999999 | TEST | 0000 | C1111111 | 0 | 00 | 0 | TMS338790 | -6.100 |