@Christian: In common case the emulation of left join semantic don't work. I tried.Emulate don't work because "on" clause of "left join" have applied to joined table and "where" clause to final result set. Sad to say that in eclipselink this works. Can't believe that i should use native sql...