help needed to solve the query

[Ahmed khan]

i have two table Agent and Ad

i want to select all the agents with / without ads

when i use right join the Hibernate throws exception

can anybody write an equivalent query so that i dont have to use join

here is the query

select ag.id, ag.name, ag.brokerage, count(a),
(select count(a2) from Ad a2 where a2.agent.id = ag.id and a2.adStatus ='new' or a2.adStatus= 'off market' from Ad a right join Agent ag on a.agent.id = ag.id

Thanks in advance