[EMAIL PROTECTED] wrote:
So I could just use SELECT ..., SUM(`downloadCount`) FROM ... WHERE `pid` = (SELECT `id` FROM ...) GROUP BY `price`; Is that going to do the same as SELECT SUM(`downloadCount` FROM (SELECT ... FROM ... WHERE `pid` = (SELECT ...)) GROUP BY `price`; ?
Yes, these two will produce the same result, but the first query is probably more efficient.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------