SELECT * FROM fb.order LEFT JOIN item on order.item_name = item.item_name WHERE fb.order.order_status = 'Served' and tab_name='A'
I have two different tables "order" and "item" which i joined using left join.
In order table there is a column name called quantity and in item table, there is a column called price.
What i need to do is multiply the quantity from order with the price from item then get a total value.
There will be several order records added together for the final sum...
Can anyone point me, how to code the counting part in php.