SQL inner join question

[Ivan Smahin]

Hello Martin,

Thursday, November 29, 2007, 3:53:39 PM, you wrote:

> 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?

Seems to be a bug - report it to Mantis please



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com