本文主要介绍了symfony2联合查询实现方法，结合实例形式简单分析了symfony2联合查询的具体步骤与实现技巧。需要的朋友可以参考下，希望对大家有所帮助。
1.yml文件
acme\mspadminbundle\entity\msparticle: type: entity table: msp_article manytoone: channel: targetentity: mspchannel inversedby: articles joincolumn: name: channel_id referencedcolumnname: channel_id user: targetentity: mspuser inversedby: userone joincolumn: name: user_id referencedcolumnname: user_id
acme\mspadminbundle\entity\mspchannel: type: entity table: msp_channel onetomany: articles: targetentity: msparticle mappedby: channel
acme\mspadminbundle\entity\mspuser: type: entity table: msp_user onetomany: userone: targetentity: msparticle mappedby: user
2.查询代码：
$sql="select a.id,a.checkstatus,a.title,a.releasesysdate, a.visittotal,u.username ,n.name from acmemspadminbundle:msparticle a join a.user u join a.channel n"; $query = $emt->createquery($sql." where a.checkstatus = 0 "); $mspartile = $query->getresult();
相关推荐：
详解symfony2控制器的用法
详解symfony2框架创建项目和设置模板
详解symfony在模板和行为中取得request参数的方法
以上就是详解symfony2实现联合查询的方法的详细内容。