I'm quite stunned: I'm using a named-query that includes a where-clause giving me no results. When I manually run the same query against the Oracle database, I'm getting results (records). I'm doing tests on an in-memory database, gives me results.
The query looks like:
<sql-query......>
SELECT ....
FROM table1 t1
INNER JOIN table2 t2 etc
WHERE t1.field = t2.field
</sql-query>
When I remove the where-clause, I'm getting data.

I don't believe WHERE is broken, but what is?

It's difficult to answer your question because there's very little detail. Can u divulge a bit more ?
minimal mapping file and what entities u saved

lastly the fact that the query without the 'where-clause' works means maybe u were expecting a left join and not an inner join in the first place.