honestly, though - I've read and re-read it over several times and I just don't get it. Would you mind walking me through it a bit? There's clearly some bit of information that I'm not getting.
> 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 (SELECT n_r_id FROM notes_to_the_record_shared WHERE id = > #session.user.id#) > > No DISTINCT necessary. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
