Monday, December 2, 2013

JOIN in belongsTo (but not HABTM)

Is this possible?

Situation:

Users have many Items

I want to pull a User's total inventory, which sits in the inventory table. But I also need to pull some fields from the master item table (like item name) or to be able to pull items only be their type (this data sits in the master table)

Is it possible in a belongsTo relationship to do a join that involves joining on a key that isn't the foreign key used in the belongsTo relationship? 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

No comments: