Search Posts

Author: Hashir Anwaar

left join count ignore left table column from counting

how to – left join count ignore left table column from counting I have two tables …first has order_id, order_status, and user_id …. second table has order_id ,and product_id, product_quantity like below 1st table order_id | order_status | user_id —————————- 1 | 5 | 2 2 | 1 | 1 3 | 5 | 1 4 | 5 | 1 2nd Table order_id | product_id | quantity —————————- 1 | 200 | 4 2 | […]