I have two tables items and sale_invoice_items , items has a flag indicating if the item expires, and sale_invoice_items has the expiry date. now when doing SELECT to return an invoice I'm doing:
I have two tables items and sale_invoice_items , items has a flag indicating if the item expires, and sale_invoice_items has the expiry date. now when doing SELECT to return an invoice I'm doing: