Often times you will need to query a distant table based on a condition on a close table. For example we have a store that has a table structure like the following: Now we want to find the Division that a particular Item belongs to. In normal SQL we could do
![Posts | Mark Story](https://cdn-ak-scissors.b.st-hatena.com/image/square/a68fe216fa8ba61824e80174c9da8fa907c90074/height=288;version=1;width=512/https%3A%2F%2Fmark-story.com%2Fimg%2Fmouth-icon-large.png)