alright - I see why it doesn't need to do a JOIN. but just to be sure I understand, the line: n.n_r_id IN (#idlist#) All it does is say give me everything in the subquery - it seems to me. And really, that's just making two sets of records into one set - which is a cool idea and very readable.
>Then do the second query... > ><cfquery name="q2"...> >SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe >FROM notes_to_the_record n >WHERE n.ID = #session.user.id# >OR >n.n_r_id IN (#idlist#) ></cfquery> > >The IN just compares a column to a list of values...it does not create a >JOIN...in fact, as you can see above, it doesn't even need to know about >the second table. Using the subquery is just a way to get that list of >values. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
