Sql help

[dhimok]

Hello

 

I have two tables 1. products 2. orders

 

How can i select the 5 top sold products from orders? Orders table holds product_id and the quantity

 

thanks

[isaac_cm]

something like that

 

select sum(quantity) as Q from products, orders

where order.prod_id = products.prod_id

group by prod_id

order by Q

limit 5

 

 

 

[dhimok]

I get this error

 

Column 'product_id' in group statement is ambiguous

[isaac_cm]

you have to add it to select clause like this

 

select product_id, sum(quantity) as Q from products, orders

 

[dhimok]

stil it doesnt change

[isaac_cm]

try this products.prod_id

[fenway]

Better yet, use a JOIN, and use ORDER BY yourField desc