I've been struggling with this problem for a while now, I can't get this one worked out.
Database structure:
i.imgur.com/VzAdlKh.png
I have two tables, tbl_orders and tbl_clients.
I have an Excel spreadsheet that the company previously used to store this data - a very basic setup where each...