Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. SELECT
  2. invoiceheader.id,
  3. invoiceheader.customerlastname,
  4. invoiceheader.customerfirstname,
  5. invoiceheader.customernit,
  6. invoicedetail.productid,
  7. invoicedetail.quantity,
  8. invoicedetail.saleprice,
  9. (quantity * saleprice) as Total
  10. FROM invoiceheader
  11. INNER JOIN invoicedetail
  12. ON invoiceheader.id = invoicedetail.invoiceid
  13.  
  14. InvoiceHeader::select('invoiceheader.id', 'invoiceheader.customerlastname',
  15. 'invoiceheader.customerfirstname', 'invoiceheader.customernit',
  16. 'invoicedetail.productid', 'invoicedetail.quantity',
  17. 'invoicedetail.saleprice', DB::raw('(quantity * saleprice) as Total'))
  18. ->join('invoicedetail', 'invoiceheader.id', '=', 'invoicedetail.invoiceid')
  19. ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement