WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

Data extraction issue with two tables

TangledPubes

New member

0

0%

Status

Offline

Posts

39

Likes

0

Rep

0

Bits

205

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
 

249

6,622

6,642

Top