Mysql – How to Display total cost of boxes i.e (no_of_boxes*cost_per_box) against common PID i.e. Product-ID column contained in two different tables?
Cost per box is in the table named products whereas no of boxes is in sales table. PID is common in both tables both are in same schema and database. I want total cost of boxes per PID shown against…