M
maxzsim
Hi,
I have created 2 tables with Txn_IDA for Tbl A and Txn_IDB for Tbl B and
the field type is of ReplicationID.
I have created a query that tries to link using these 2 fields but it
return no row. however, when i manually use a Ctlr-F to find i can see there
are rows of the same TXN_ID on both table
Can anyone advise ?
my solution is to use mid(TXN_IDA , 2 , 36) = mid(TXN_IDB , 2 , 36) to do a
matching but it's very slow somehow
tks & rdgs
I have created 2 tables with Txn_IDA for Tbl A and Txn_IDB for Tbl B and
the field type is of ReplicationID.
I have created a query that tries to link using these 2 fields but it
return no row. however, when i manually use a Ctlr-F to find i can see there
are rows of the same TXN_ID on both table
Can anyone advise ?
my solution is to use mid(TXN_IDA , 2 , 36) = mid(TXN_IDB , 2 , 36) to do a
matching but it's very slow somehow
tks & rdgs