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
On 1/23/07, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I have a table (notes_to_the_record) of meeting notes
> (fields:n_r_id,id,meeting_name,date_added,follow_up).
> A new feature is that the meeting note is shared to a set of users.
> So since multiple users can be selected, I made a new table called
> notes_to_the_record_shared (n_r_shared_id,n_r_id,id).
> In both those, id references a People table, so it's the person's ID
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:267281
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
