no, it'd pull the first distinct combination of rgcompany and rg_id, then
move on to the next. it's a distinct record ("record" as defined by the
columns you're selecting)
On Tue, Sep 23, 2008 at 10:53 AM, 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:270561
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
