If you're using "left join," yes, outer is assumed. You can put it in there - it's more explicit. Also, the other guy was right that you can also put the where n.id = #session.user.id# in the ON clause, which will filter your records at the level of the join. You should get the same results, and they might be slightly faster by doing it that way. You'd have to do an explain plan and compare to see if it makes any noticable difference in your case.
You're using Oracle man - you should be doing joins all the time. Joins are your friend. :) On 1/23/07, daniel kessler <[EMAIL PROTECTED]> wrote: > Yes - that worked fine and is largely the same as Ben's - except that his > states OUTER. Is the OUTER assumed when it's not stated? > > Just so that I understand - the relationship is made on the ON, which > designates a subset. Then that is queried with the WHERE. > > and thank you very much. It helps me alot. > > >I think what you really want is something like this: > > > >SELECT n.meeting_name,n.type,n.note_date,n.notes,n.type_describe > >FROM notes_to_the_record n LEFT JOIN notes_to_the_record_shared s on > >n.n_r_id = s.n_r_id > >WHERE > > n.ID = #session.user.id# OR > > s.id = #session.user.id# > >ORDER BY UPPER(n.meeting_name) ASC > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
