Microsoft Jet can choose from five join strategies. Each of these join strategies serves a particular purpose and ranges in complexity from a “brute force” table scan to more complex execution plans. The five join strategies are nested iteration, index, lookup, merge, and index-merge.