mercredi 4 octobre 2017

Using And Clause in Laravel Query Bulider

I have the following query:

    SELECT
  customers.CustCompanyName,
  addresses.AddressLine1,
  orders.*
FROM orders
  INNER JOIN customers
    ON orders.CustID = customers.CustID
  INNER JOIN customer_addresses
    ON customer_addresses.CustID = customers.CustID
  INNER JOIN addresses
    ON customer_addresses.AddressID = addresses.AddressID
    AND orders.CustAddID = customer_addresses.CustAd

How do I incorporate the AND clause in using laravel Query Builder:

$orders = DB::table('orders')
        ->join('customers', 'orders.CustID', '=', 'customers.CustID')
        ->join('customer_addresses','customer_addresses.CustID', '=' , 'customers.CustID' )
        ->join('addresses','customer_addresses.AddressID','=','addresses.AddressID')->AND

I can't find any working examples using the AND clause.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire