Thanks for your explanation.

So if we set referencemap then no need to use join.Otherwise,if we can write a normal query in model (MVC).Both works in ZF.

i am giving a thread which was posted in ZF

Linking two tables with many2many relation

here we can see that left join is used in the model class with referncemap.Is it correct or not.I am doubtfull

Thanks