SQL question....

If i have listings of home poker games pulled from a SQL database and the game
have 3 characteristics:

Listing creation date
State of game
Premium listing or free listing

Can I have it so that I pull the game up like this?

PREMIUM LISTINGS - Ohio only
Created 01/01/2004 - premium listing
Created 01/02/2004 - premium listing
Created 01/03/2004 - premium listing

FREE LISTINGS - Ohio only
Created 01/01/2004 - premium listing
Created 01/02/2004 - premium listing
Created 01/03/2004 - premium listing

So basically have it pull data by state only then do a sort for Premium or Free
listing and then a secondary sort by date

select *
From TableName
Where State='xx'
sort by ListingType desc,
  CreateDate
 
On Tue, 03 Aug 2004 03:06:18 +0000, Kkiely wrote:

 > If i have listings of home poker games pulled from a SQL database and the game
 > have 3 characteristics:
 >
 > Listing creation date
 > State of game
 > Premium listing or free listing
 >
 > Can I have it so that I pull the game up like this?
 >
 > PREMIUM LISTINGS - Ohio only
 > Created 01/01/2004 - premium listing
 > Created 01/02/2004 - premium listing
 > Created 01/03/2004 - premium listing
 >
 > FREE LISTINGS - Ohio only
 > Created 01/01/2004 - premium listing
 > Created 01/02/2004 - premium listing
 > Created 01/03/2004 - premium listing
 >
 > So basically have it pull data by state only then do a sort for Premium or Free
 > listing and then a secondary sort by date

--
George Sexton
MH Software, Inc. - Home of Connect Daily Web Calendar
<a style='text-decoration: underline;' href="http://www.mhsoftware.com" target="_blank">http://www.mhsoftware.com</a><!-- ~MESSAGE_AFTER~ -->