Is it possible to perform some kind of join of one table with another, where the second table is just a list of names. I want everything extracted from the first table, where the linked column in the first table contains the value in the second table. i.e. a LIKE *name* clause. So the join doesn't have to be exact, just 'contain' the value in the table which has a list of names.
So, if the first table containted the name 'John Fox''and the second table has the value 'Fox' then the first tables row will be returned since Fox is found within John Fox. Does that make sense?
(I just want to do this in ACCESS, although i'd like to know the sql syntax also)