TangledPubes
New member
0
0%
3
Months of Service
0%
I have two tables named products and branches. The branch_id in branches is linked to producto's product_branch. I want to find out how many products are in each branch, but it's not working. The SQL query I tried is below: SELECT branch_name, COUNT(product_quantity) as product_count FROM products, branches WHERE branches.branch_id=products.product_id