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

Reply via email to