>What database are you using? I've never see that "+" notation before...
Sorry - I reminded myself twice while writing the email to state the DB and dang it. It's Oracle and yes the + stands for Outer Join - which I just learned yesterday. I read and re-read your point twice and I believe that I have it. I do Joins so infrequently that I hope I remember it cause it looks like good advice. >The idea is that instead of using "FROM a, b WHERE a.id = b.id" you >instead do "FROM a JOIN b ON (a.id = b.id)", and you leave the WHERE >clause to be only for non-joining constraints. It can really clear up >ambiguity (for the person reading the code, including the person who >wrote it), and it does away with special notations for OUTER joins, >which is what I suspect that "+" is for. (Outer joins look like "FROM a >LEFT OUTER JOIN b ON (a.id = b.id)", etc.) > >As to your specific problem, how are the notes_to_the_record and >notes_to_the_record_shared tables related to each other and to the user? >I can't tell if your "id" field is the user id or the note id. I seem to have the problem solved. But the id is the id of the person. The note has it's own ID which is n_r_id and the shared items have their own id which is n_r_shared_id. Each of them contain the id field and they're related through that and the notes themselves are related to my central People table. I really appreciate the help everyone. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
