title: how to create select join multiple condition in laravel 5.3
body: <p>how to create select join multiple condition in laravel 5.3</p>
  
  <p>SQL SELECT Statement.</p>
  
  <pre><code>SELECT  table_1.column_1
          ,table_2.column_1
          ,table_3.column_1
  FROM    table_1
  LEFT JOIN   table_2
  ON  table_1.column_1 = table_2.column_1
  LEFT JOIN   table_3
  ON  table_1.column_2 = table_3.column_2
  AND table_3.column_3 &lt;= NOW()
  AND (   table_3.column_4 &gt;= NOW()
          OR table_3.column_4 = 0
      )
  WHERE   table_1.column_1 = '0000000001'
  </code></pre>
  
  <p>I want to convert SQL Statement to laravel select.
  I try.</p>
  
  <pre><code>$result = DB::table('table_1')
            -&gt;select('table_1.column_1', 'table_2.column_1', 'table_3.column_1')
            -&gt;leftJoin('table_1', 'table_1.column_1', '=', 'table_2.column_1')
            -&gt;leftJoin('table_3', 'table_1.column_2', '=', 'table_3.column_2')
            -&gt;where('table_1', $_POST['id'])
            -&gt;get();
  </code></pre>