shergar1983 Posted June 25, 2008 Share Posted June 25, 2008 Guys, This is embarassing and has been bouncing round the office all day. The example: table1.field1 has first names and middles names e.g. Edward Martin. table2.field1 has just first names e.g. Edward. I need to have a select join which shows all those records where table1.field1 contains table1.field1. It is this type of join I am trying to solve rather than a different approach to the example which is ficticious. Any help would be much appreciated. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 25, 2008 Share Posted June 25, 2008 You can use wildcards to join 2 tables, it's just not efficient. Quote Link to comment Share on other sites More sharing options...
shergar1983 Posted June 25, 2008 Author Share Posted June 25, 2008 oh okay, any suggestions? I can't think of any... Quote Link to comment Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 Not really -- inexact matches are poor to begin with. Why is your data stored this way? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.