Snipplr http://snipplr.com/language/mysql/tags/join Recent snippets posted on Snipplr.com en-us Thu, 23 May 2013 06:08:42 GMT (MySQL) Number of records in one table of a type from another table. - jbranca http://snipplr.com/view/40248/number-of-records-in-one-table-of-a-type-from-another-table/ 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).

]]> Fri, 10 Sep 2010 06:09:16 GMT http://snipplr.com/view/40248/number-of-records-in-one-table-of-a-type-from-another-table/ (MySQL) Delete Orphaned Records - nkm http://snipplr.com/view/20337/delete-orphaned-records/

]]> Mon, 28 Sep 2009 05:46:54 GMT http://snipplr.com/view/20337/delete-orphaned-records/