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