adding a sum query into a standard select query vs separating them?

[schilly]

So I need to display a list of applications and then tally total downloads for each application. Normally I would do something like:

 

select all the applications, loop through the results then perform another query to get the total downloads for each application. basically n+1 queries.

 

ie.

 

SELECT * FROM applications

 

loop through and for each iteration do SELECT sum(download) FROM app_downloads WHERE app_id = x

 

 

 

Can I add a sub query into my original select query to create a column for a total downloads? 1 query vs n+1 queries. And is it faster than doing the method above?

 

Let me know if you need any further info.

 

Thanks.

[schilly]

well i got my query working and i'm guessing it would be faster than running n+1 queries.