Compare data from two db tables using CF
I have two database tables. I want to compare fields from tbl_one with fields from tbl_two and the output the resulting similarities.
So, I want to take table_one.field_one and compare it to table_two.field_one. If they match, I'd want to output something like "CORRECT", and if not "INCORRECT". Or even better might be to simply compare the 10 fields from table one to the corresponding ten fields in table two and then output the number of matching fields.