<code>**Order** table .2**order_items** table 4.**products** tables
Want to create a Report page in Code Igniter. For that i have two tables in My Sql , want to select attributes from them and Display in a single tables.FOR PRODUCT WISE SALES REPORT AND PRODUCT WISE PROFIT.What is the best way to do this.
attributes:
1.order table: id, bill_no, date_time, gross_amount, service_charge_rate, service_charge_amount, gst_charge_rate, gst_charge_amount, discount, net_amount, user_id, table_id, paid_status, store_id PRIMARY KEY (id)
- Order_Item order_items
(id,order_id,product_id,qty,rate,amount, PRIMARY KEY (id`) - Product Table: products
(id,category_id,store_id,name,price,description,image,active, PRIMARY KEY (id`)
