Wiki articles in category How-tos tagged with "relations"

When one needs to select a record in a table that do not have related records through a relation, it is generally suggested to use a subquery. Personnaly, I prefer a high level approach, and I have a method to do it with scopes.

I could make this work following same useful tips from this post.

I keep a reference to some simple but painful task if you forget a common or something. I am new to Yii and this took awhile for me to figure out. Everything I read said do this or do that and not a single one worked for me. However, the following did.

Sometimes the right place to store application data is in a join table. For example, movie viewers either like or don’t like the movies they watched.