yups - just figured that one out.
/me smacks self in head ...
On Tue, Sep 23, 2008 at 1:55 PM, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> 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:270563
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
