学说加入多个表 [英] doctrine join multiple tables

问题描述

刚开始使用教条。题。我有一个查找表，做2连接。如何在Doctrine中执行此操作？

我的SQL语句在mysql中如下所示

 code> select * from Business b 
内部连接BusinessCategoryLookup on b.BusinessID = BusinessCategoryLookup .BusinessID内部连接BusinessCategory bb on b.BusinessCategoryID = BusinessCategoryLookup .BusinessCategoryID; 
  

本质上，我需要返回他们所属的所有业务及其相关类别。 Lookup表只是categoryID，业务ID作为列。

解决方案

假设您的业务实体有 businessCategoryLookup 和 businessCategory 字段：

  SELECT b ，bcl，bc FROM YourBundleName：Business 
 JOIN b.businessCategoryLookup bcl 
 JOIN b.businessCategory bc 
  

比SQL更清晰，呃？ ：）

Just started using doctrine. question. I have a lookup table that does 2 joins. How can I do this in Doctrine?

My SQL statement looks like this in mysql

select * from Business b 
inner join BusinessCategoryLookup on b.BusinessID= BusinessCategoryLookup .BusinessID inner join BusinessCategory bb on b.BusinessCategoryID= BusinessCategoryLookup .BusinessCategoryID;

Essentially I need to return all the business and their associated categories they belong too. The Lookup table is just categoryID, business ID as the columns.

解决方案

Assuming your Business entity has businessCategoryLookup and businessCategory fields:

SELECT b, bcl, bc FROM YourBundleName:Business
JOIN b.businessCategoryLookup bcl
JOIN b.businessCategory bc

A lot clearer than SQL, eh ? :)

这篇关于学说加入多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！