Advanced Search

Return to Snippet

Revision: 31665
at October 8, 2010 06:12 by jbranca
Updated Code 
SELECT DISTINCT g.gallery_name, g.gallery_id, count(g.gallery_id) AS sum 
FROM galleries AS g 
JOIN images AS i 
ON g.gallery_id = i.gallery_id
GROUP BY g.gallery_id
ORDER BY sum ASC

Revision: 31664
at September 10, 2010 06:09 by jbranca
Initial Code 
SELECT DISTINCT g.gallery, g.nid, count(g.nid) AS sum 
                       FROM galleries AS g 
                       JOIN images 
                       ON g.nid = images.gallery 
                       GROUP BY g.nid 
                       ORDER BY sum ASC
Initial URL 
count-of-joined-records
Initial Description 
You have two tables galleries and images, and you need to know how many images each gallery has associated with it.  This Query returns the sum of distinct record joined to another table by a common field (gallery_id).
Initial Title 
Number of records in one table of a type from another table.
Initial Tags 
mysql
Initial Language 
MySQL