Did you have any luck on this? It looks like the best I can do is return one row from the left table and between 0 and many possible matches for the right table. I am using string searching to do this. I am trying to match on partial name and city.

Thx.

John