Forum Discussion
Solved
Comparing Values From Different Non-Related Tables
Hi All, I have a query that I can't seem to figure out. Do to one of my tables having information and not having a relationship with other I wanted to see if there is someway I could compare the two ...
You should try to relate them. What I would do is create a composite key by concatenating two fields into 1 and joining the two tables together on the newly created fields.
UrgencyId & SLA_RecID = 7 &"|"& 2
UrgencyID & SR_RecID = 7 &"|"& 2
You should try to relate them. What I would do is create a composite key by concatenating two fields into 1 and joining the two tables together on the newly created fields.
UrgencyId & SLA_RecID = 7 &"|"& 2
UrgencyID & SR_RecID = 7 &"|"& 2
This worked great! Thank you.
