Doctrine Join Multiple Tables

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 i

Solution 1:

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 ? :)