UNION in createQuery with symfony2

Question

I'm trying

$query = $em->createQuery(
            'SELECT id, name, beginDate, endDate FROM SmartguideEntityBundle:Promotion1 UNION SELECT id, name, beginDate, endDate FROM SmartguideEntityBundle:Promotion2'
        );

But result is

Error: Expected end of string, got 'SELECT'

How can I resolve it

possible duplicate of [Symfony createquery with union](http://stackoverflow.com/questions/22453104/symfony-createquery-with-union) — Moonchild, Apr 28 '15 at 11:29

score 1 · Answer 1 · edited May 23 '17 at 12:17

1

Try to define an alias, as in

SELECT p1.id, 
p1.name, 
p1.beginDate, 
p1.endDate 
FROM SmartguideEntityBundle:Promotion1 p1 
UNION 
SELECT p2.id, 
p2.name, 
p2.beginDate, 
p2.endDate 
FROM SmartguideEntityBundle:Promotion2 p2

EDIT: If you take a look at this link, ti shows how to execute the query using RAW SQL (SQL query with UNION in Doctrine Symfony)

edited May 23 '17 at 12:17

Community

1
1

answered Aug 05 '13 at 08:07

Christian Phillips

18,399
8
53
82

I got message "Error: Expected end of string, got 'UNION' when using alias – hoangvu68 Aug 05 '13 at 08:09

score 0 · Answer 2 · answered Mar 27 '17 at 03:05

0

$stmt = $em->getConnection();
$result = $stmt->executeQuery(-your sql-)->fetchAll();

answered Mar 27 '17 at 03:05

林洋洋

1

UNION in createQuery with symfony2

2 Answers2