Re: sql help

select * from table order by flag desc, contract, master

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


|---------+------------------------------->
|         |           "Smith, Mike"       |
|         |           <Mike_Smith@RGCResou|
|         |           rces.com>           |
|         |           Sent by:            |
|         |           midrange-l-bounces@m|
|         |           idrange.com         |
|         |                               |
|         |                               |
|         |           01/26/2004 03:08 PM |
|         |           Please respond to   |
|         |           Midrange Systems    |
|         |           Technical Discussion|
|         |                               |
|---------+------------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       To:       "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>                                            |
  |       cc:                                                                   
                                                 |
  |       Subject:  sql help                                                    
                                                 |
  
>------------------------------------------------------------------------------------------------------------------------------|




I have a file that has  a contract#, a flag that indicates if the file
is a master contract, and a master contract#
so i might have something like

contract    flag    master
1                y
2                y
3                n        1
4                n        2
5                n        1


where contract 1 is a master contract with subordinate contracts 3 and 5

i'm trying to create an SQL statement that will list the master
contracts and the subordinate contracts. So far i haven't been able to
get this to work.  Can i do this in 1 statement.

i want results such as


contract    flag    master
1                y
3                n        1
5                n        1
2                y
4                n        2
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.