understanding how a relational field calculation work?
I have two databases where I have a field in each called "Part #" and "Part Number". The part numbers in the fields are in different orders and some of them are in one field but not in the other and vice-versa. I created a calculation field called comparison, where I used the "exact" function to see if they are equal or not. The result is either "match" or "not match". I obtain the correct result, but I would like to understand how does the related calculation work? How does it find the corresponding part number if its not in the same order as the other field and then compares it? Does it follow the inner join, left join, and right join operations perhaps?