<--- --------------------------------------------------------------------------------------- ---- Blog Entry: OOPhoto - Almost An Object Oriented ColdFusion Application Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1312.view Date Posted: Aug 7, 2008 at 9:45 AM ---- --------------------------------------------------------------------------------------- ---> SELECT c.id, c.comment, c.date_created, c.photo_id FROM comment c INNER JOIN photo p ON ( c.photo_id = p.id AND p.id = ) ORDER BY c.date_created ASC