ZEND 2. Union . Add Limit to UNION query -

I have a SQL query like below and I would like to create it in Zend Framework 2.

(from the ID ID from the exp_personal_data ORDER city) by select ID ID (select ID id from PD_ unregister)

I would like to be a union and add to this limit , By order

$ this -> _ select-> Coalition ($ selectPdContest, 'union all');

When I type queries in this way

$ this -> _ select-> ($ selectPdContest, 'union all') -> boundary ('10);

The query looks like this:

(SELECT id as exp_personal_data ORDER based on city limit 10) Union Pd_unregister)

Limit only choose firs. I want such a limit will be added.

(ID from SEND id as EX_personal_data ORDER from city) UNION (pd_unregister by selecting ID id) LIMIT 10

How to do this in Zend Framework 2 is?

Add these lines will work,

$ select1 = select new one ( ); $ Select1-> Coalition ($ selectPdContest, 'union all');

$ select3 = Select new (); $ OneTwo = $ select3-> (['sub' => $ select1]) -> Border (10);