Perhaps this is easy for someone so I figured I'd ask. Here's the scenario:
USERS TABLE ----------------- USER_ID USERNAME etc... COMMENTS TABLE ------------------------- COMMENT_ID USER_ID COMMENT etc... I know I can query USERS and then loop through the results fetching the comments... but I'd rather not do that. Here's the results I'm trying to get... in a SINGLE query if possible: USER_ID,USERNAME,MERGED_COMMENTS 1,joe,comment1<br>comment2<br>comment3 2,sam,comment 3,sue,comment<br>another comment<br>etc. Any ideas? -Novak ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
