Join in symfony

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery(‘SELECT p.id as empid,p.userId,p.employeeName,p.employeeAge,p.employeeSchoolname,p.employeeAddress,p.employeeEducation,p.employeeDesignation,p.employeeCompany,p.employeeMaritialStatus,p.employeeMobno,p.employeePhoneno,q.id,q.username
FROM AdminEmployeeBundle:Employee p INNER JOIN AdminManageruserBundle:Register q where p.userId=q.id’ );

$entities = $query->getResult();
return $this->render(‘AdminEmployeeBundle:Default:view.html.twig’, array(
‘entities’ => $entities,’sessionid’=>$sessionid,
));

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s