query unmatch items

[raychow22]

I want to compare two of the same tables which are updated per time. I want to find out what unmatched records that are possibly was changed over time. There are multiple fields (10).



Thanks,

[CJ_London]

you can left join from one table to the other on all the fields that are relevant. The unmatched wizard should take you through the steps. I believe 10 such joins are doable, otherwise you will need to hash the fields to create a unique value and match on that.

[raychow22]

This is what I got so far. I tested it out by changing some of the data to make it unmatch and the query resulted in the record with the unmatch fields; However, I cannot do this for all fields, especially Multi-Value Fields... Ajax, any experience with dealing with MVF?

Thanks,

[CJ_London]

Ajax, any experience with dealing with MVF?

yes, and my experience tells me to avoid them like the plague for any serious development. They have too many limitations for an efficient design. You need to join on value to value, if you can't then looks like this is another reason not to use them. If you can't then you will need to create a joining table and populate it with the hidden values in your MVF field - I'll explain how if this is necessary, but I'm not going to be around much for the next couple of days