daniel kessler wrote: > Here are the results from the dump (not sure how this'll come through) > ommitting unnecessary info.
Can you re-paste this dump without ommitting anything...I'm guessing there is some necessary info in there. My guess is that the s.id is being returned in your result set, and since that isn't always 3, those are distinct records. Another way of doing this query might be something like... 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:267763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
