I have a situation where I need to return two column from different tables with different values.
This is my table.
Here's my code :
SELECT products_name, qty_in, qty_out FROM `products`
LEFT JOIN products_in ON products.id = products_in.product_id
LEFT JOIN products_out ON products.id = products_out.product_id
ORDER BY products.id ASC
And the result :
It should be return like this.
Help me. How to return all columns with NULL values is still there.