Doctrine -> pager -> request -> union ? help please ! - doctrine-user

hi doctrine users,

i'm searching how to do an union between two dql request or an other way to do the request.

schema : table1 =>
int id
int parent_id

table2 =>
int id
int table1_id
string name

(i want the list of table1's item with names, only parents table1's item have a name, and childs table1's item muse display their parent name).

select table1.id, table2.libelle
->from(table1 table1)
->leftJoin(table1.table2 table2 on table.id = table2.table1_id)
>>>>>UNION<<<<<<
select table1.id, table2.libelle
->from(table1 table1)
->leftJoin(table1.table2 table2 on table.produit_id = table2.table1_id)

I need the result of this two requests in one to use correctly the Doctrine pager, (i would avoid to do it with php treatments(=>dirty))

so, i need your help !! how can i do?

[Updated on: Wed, 16 September 2009 13:24]

Version: