I get an error from the following HQL query string:

"from creditor c in join c.outstandingBalances b where b.creditorBalanceID.accountNumber = :tan"

The error is:

net.sf.hibernate.QueryException: in expected: c [ ...query string...]

I invoke query as:

list = session.createQuery(qstring).setInteger("tan", 2).list();

Why would it expect an 'in' clause? More generally,
where can I find formal syntax for HQL?

Rob

Fix your classname ("creditor" is not the name of a class).

A formal syntax is in Hibernate3/grammar

Sheesh. I guess it is hard to distinguish between
lower case c and upper case C at 2AM.

Thanks.