Victor2020 wrote:

Using 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.


SELECT tbl1.*, tbl2.*
FROM tbl1, tbl2
WHERE tbl1.field Like "*" & tbl2.field & "*"
Or tbl2.field Like "*" & tbl1.field & "*"

--
Marsh
MVP [MS Access]