Return similiar text in two tables.

[OMALLY]

I have two tables, each with a text field. One field has text that is a modified version of the other table field's text.

Example:

Table 1
"RD S (LA VETA AVE)"

Table 2
"LA VETA AV"

1. I want to find records in Table 2 that has text present.
2. Match that text to Table 1.
3. Return a table with both fields.

I would imagine I'd have to use wildcards and some form of LIKE but I'm having troubles getting anything to return. Thanks in advance.

 

[MSAccessRookie]

You did not say the names of the text items, or how the tables were joined to each other, but this code might do what you want.

SELECT Table1.TextItem, Table2.TextItem 
From Table1 Inner Join Table2 On { Whatever they Join on }
Where Table1.TextItem LIKE "*" & Table2.TextItem & "*"