J
Justin
I have two tables that are being imported to my database. I am trying to make
a query where both tables will search to see if the amount + id are equal.
Now, I tried the unmatched query but now I just saw this problem that is
accurring.
The majority of times, the ID are 4 digts but sometimes table A will be only
3 digits so when i try to do the query, it is saying that this is an error,
when in fact, if I checked manually, both are equal. Now i found out that the
first 3 digits are to be looked @, from both tables. I need help on making a
query where
both my tables (table A and B) will search each other, check first the ID
(the first 3 digits) and also the amounts.
a query where both tables will search to see if the amount + id are equal.
Now, I tried the unmatched query but now I just saw this problem that is
accurring.
The majority of times, the ID are 4 digts but sometimes table A will be only
3 digits so when i try to do the query, it is saying that this is an error,
when in fact, if I checked manually, both are equal. Now i found out that the
first 3 digits are to be looked @, from both tables. I need help on making a
query where
both my tables (table A and B) will search each other, check first the ID
(the first 3 digits) and also the amounts.