SQL inner join question

[Martin S.]

Hello,

does anybody know why this query does not work? i get no records with it:

SELECT table1.*,table2.* FROM table1 INNER JOIN table2 ON 
table1.id=table2.t1_id WHERE (table1.a LIKE '%test%') OR (table2.a LIKE 
'%test%')

physically, in table1, there are records that have "test" in the 
"a"-fields and in table2, there are records that have "test" in the 
"a"-field indeed.

can anybody help?

greetings,

Martin