[b]Hibernate version:[/b]
2.1.8 on MySQL

This issue was found in the TOOLS forum, but after reading my addition to the post, you'll see it appears that it is not a tool(xml generator) issue, so I'm posting a link here.

The issue is.. HSQL taking form "from tablename" does not work, but the same hbm.xml works for form "from tablename e where e.column = (or like) ?"

The sql generator is prefixing the tablename with underscore, which is fine for an alias, but it results in "table not found" when not kept seperate.

Please the the original post for more details and stack
I also included HSQL forms I tried as a workaround that may be considered for future support.

Thanks

oops,
here's the link

http://forum.hibernate.org/viewtopic.php?t=939095