I found the solution. I added an order index field to the table and in the join left command used the max() parameter.

I have been attempting based on the order of the rows in the second table. I could add another column as an index number to set the order if...

I tried the code specified, and it worked like my prior code where it returns every match. So every tool free number returns once as a free call and...

The 1__________ will match because the format of a long distance number 1 followed by 10 underscores is the same as an 1800 number format. My idea is to...

Here is a sample table structure and some sample data. If I run as is I would get two matches for the 1800 number, one free, and one that...