UNION query in propel ORM v1.6

0
votes

I am converting some existing queries into propel ORM. Now i am stuck with converting following similar query in propel.

(SELECT name,address,phone FROM table_1)
UNION
(SELECT name,address,phone FROM table_2)
UNION
(SELECT name,address,phone FROM table_3)

What would be the proper propel implementation for the above query?

1
phpmysqlpropelpropel2

1 Answers

0
votes

This is a rather complex query, you might be better off creating a view from the select and then create a read-only table in your xml schema with the same columns. It has the same beheviour.

<table name="my_table" readOnly="true">