I have two tables, photos and comments. Their structures are as follows: photos table ------------------ photoID photoTitle
comments table ------------------ commentID commentText photoID_fk I need to write a query that will allow me to display all the records in photos while also displaying the comments that match up to each photoID record. Kind of like this: photoID 1 comment 1 comment 2 photoID 2 comment 3 comment 4 photoID 3 [no comments] photoID 4 comment 5 comment 6 And so on... Any help would be greatly appreciated. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
