left join / on / is null

shomburg · **Posted:** Thu Apr 22, 2004 9:27 am

Hi there,

i want to execute this query:

Code:

select inter.* from inter left join ts310
on (inter.int_kunnr = ts310.kndnr and 
ts310.leidat between "2004-01-01" and "2004-01-31")
where ts310.rechnr is null

i tried this hql query :

Code:

select inter from Inter inter left join inter.ts310List ts310
on ts310.leidat between "2004-01-01" and "2004-01-31"
where ts310.rechnr is null

but the error unexpected token: on occoured.

can anyone show me the right way ?