Posted by strawberry on 10/02/50 11:48

SELECT brand,SUM(dnote) FROM $table GROUP BY brand;

You could probably combine this with the above into a single query.
Otherwise do a "SELECT CREATE VIEW" on your first table.

• Next in forum: Re: Can somebody help me to write PHP function ? - Just in Time alghoritm.
• Prev in forum: COUNT, DISTINCT and SUM all in one
• Thread view: Re: COUNT, DISTINCT and SUM all in one

[Reply to this message]