Hm. That doesn't make sense to me. If you removed the clob and used distinct and you're still getting duplicate data, it seems rather suspicious. If you want to shoot me the ddl for the 2 tables and some insert statements for sample data, I can see if I can fiddle with it. It's Friday. Problem solving is more fun that coding. :)
On 1/26/07, daniel kessler <[EMAIL PROTECTED]> wrote: > > hmm. There's one record with n_r_id of 341 and it does have an id of > > 3. That n_r_id also is listed 4 times in the shared, but there it > > doesn't have an id of 3 at all. So once it's joined I suppose it does > > have an n.n_r_id of 3 > > err, I meant here that it has an n.id of 3, not an n_r_id - sorry > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4