gah ... nm ... OK, without the RG_ID, it does what I need it to do.
Thanks all!!! On Tue, Sep 23, 2008 at 1:53 PM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > so in theory - > > select DISTINCT RGCOMPANY, RG_ID > from REGISTRATION > order by RGCOMPANY > > is supposed to work .... ? Pulling the first distinct company name it > comes to then moving on to the next .. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:270560 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
