Wildcard with field value

  • Thread starter Thread starter ps
  • Start date Start date
P

ps

I am trying to write a query using a list
of alphanumeric characters that exist in a
table and compare that to another table
to see if those characters exist plus any
additional characters:

Table 1 Table 2
H2000 H2000A1
F5677
H2000A2
E3332
H2000
G7766
H2000A3

In the above tables. Table 1 is my manually
generated list. Table 2 is my actual database.
I am trying to flush out anything that contains
H2000. I want to get the Table 1 value and wildcard
it so that I pick up all values containing H2000.
I tried using:

Like "[Table 1][Column Name]*"

but I assume it is interpreting that as text. I
am guessing this can be done but need the right
syntax. Any pointers would be greatly appreciated....

-Peter
 
One method would be to use a non-equi join. You cannot do this in the query
grid, but must use the SQL text window to enter your query.

SELECT Table2.*
FROM Table2 INNER JOIN TABLE1
 
Back
Top