list records from the Keyword table

  • Thread starter Thread starter Ginola
  • Start date Start date
G

Ginola

two Table "tb_a" and "tb_b"

table tb_a has the following field
Keyword
CompanyName

tb_b
CompanyName

Now I like to create a table or make a query from tb_b where tb_a is
part of tb_b.CompanyName
The table or query should have the Field
- tb_b.CompanyName
- tb_a.CompanyName
- tb_a.Keyword

Does anyone know if I can do it in query or I have to write vba codes
?

thanks
 
Ginola,

if tbl_a.companyname is the text of the company name, I should think you
would be able to do it without referencing tbl_b. Something like:

select a.keyword, a.companyname from tbl_a as a where a.companyname like "*"
& a.keyword & "*"

I was thinking you'd want to see any keyword in any companyname but your
table is already associating one to the other.

HTH

Peter.
 
Back
Top