Jump to content

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


shergar1983

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.