Doctrine Multiple Join Query gives an error

Question

I m writing a query in Doctrine 2.3.3, where i want to retrieve data from 4 different tables. Now i have written a query which works on single join. But when i write multiple join queries it shows an error..

My query is

$query = $parent->entityManager->createQuery('SELECT t,s,q,d FROM TblEmployee t JOIN TblEmployeeShifts s JOIN TblEmployeeQualification q JOIN TblEmployeeDepartment d where t.employeeId = s.employeeId and t.employeeId = d.employeeId and t.employeeId = q.employeeId and t.employeeId ='.$data);

but the above query gives me an error, shown below,

[Syntax Error] line 0, col 89: Error: Expected =, <, <=, <>, >, >=, !=, got 'q'

Pls guide me where i m stepping wrong..

Community · Accepted Answer · 2014-06-28 01:57:47Z

2

This is one of the ways using which we can execute Mulitple Joins in Doctrine

$query = $parent->entityManager->createQuery('
    SELECT t,s,d,q 
    FROM TblEmployee t
    JOIN TblEmployeeDepartment s WITH t.employeeId = s.employeeId
    JOIN TblEmployeeShifts d WITH t.employeeId = d.employeeId
    JOIN TblEmployeeQualification q WITH t.employeeId = q.employeeId 
         and t.employeeId = '.$data
);

edited Jun 28, 2014 at 1:57

CommunityBot

11 silver badge

answered Apr 18, 2013 at 10:59

Sriniwas

5152 gold badges6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Doctrine Multiple Join Query gives an error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related