 class="k">LEFT</span> <span class="k">JOIN</span> <span class="p">(</span><span class="k">SELECT</span> <span class="n">field1</span><span class="p">,</span>
                      <span class="n">field3</span>
               <span class="k">FROM</span>   <span class="n">table2</span><span class="p">)</span> <span class="k">as</span> <span class="n">b</span>
        <span class="k">ON</span> <span class="n">a</span><span class="p">.</span><span class="n">field1</span> <span class="o">=</span> <span class="n