Daniel, You need to look at your database requirements from an output point of view. What I mean is this.
If I want to return data from Table A and the row from Table B that is matched by a priamry field then I should be looking at inner join. And of course it is either left or right depending on the dat you want. The reason being if you don't specify it as a left outer join or right outer join you will return all records that match for that join. HTH On 11/4/06, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > It seems convoluted to me, too. But, I'm having a hard time wrapping > my head around what you want to accomplish. It looks like you're > grouping on a non-unique field, which will of course give you multiple > results. You should be doing the cfoutput group on the n_r_id field, I > would think, if you want a one-per result. > > > > On 11/3/06, daniel kessler <[EMAIL PROTECTED]> wrote: > > > > > Is that right? It does seem convoluted so if there's a better way I'd > love to hear it. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
