SELECT * FROM table1,table2 WHERE table1.field1 LIKE '%table2.field1%' -?????

[shergar1983]

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.

[fenway]

You can use wildcards to join 2 tables, it's just not efficient.

[shergar1983]

oh okay, any suggestions? I can't think of any...

[fenway]

Not really -- inexact matches are poor to begin with.  Why is your data stored this way?