RE: Order by a field with multiple keywords

[Olive, Christopher M Mr USACHPPM]

you're subject line is close to the actual solution. :)

try.

SELECT
        fred,
        fred2,
        fred3,
        region
FROM
        sometable
GROUP BY
        region
ORDER BY
        region

Chris Olive
DOHRS Website Administrator


-----Original Message-----
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 1:22 PM
To: Cf-Talk@Houseoffusion. Com
Subject: Order by a field with multiple keywords 


Hi, All

I have a table with a "region" field that would contain several entries
(Central Coast, California, West Coast, USA). How can I display the list by
each individual region? Most records, of course will be displayed several
times in each subgroup.

All I can  think of is make a list of all regions and then run a query for
each of them. Is there a better way? With just one query?

TIA

Cyrill


----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.