nenad_jovanovski Mar 22nd, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT ii.invoice_item_id, ii.invoice_id, p.product_name, ii.line_price_net, ii.line_price_vat, ii.line_price, i.outstanding, ii.location_id, ii.appointment_id, ii.doctor_id, ii.comments, i.created FROM `invoice_item` AS ii INNER JOIN invoice AS i ON i.invoice_id = ii.invoice_id LEFT JOIN product AS p ON p.product_id = ii.product_id GROUP BY ii.invoice_item_id
RAW Paste Data