a table, say like this: name f_date s_dtae ------------------------------------------------ name1 2007-10-01 null name2 2007-06-03 2007-10-07 name3 2007-09-20 null name4 ... ...
the 'f_date' column always contains a value but the 's_date' can sometimes be null. now I want to get a collection -- all items will be in it and if the 's_date' is not null it must be ordered with 'f_date' of those the 's_date' is null. Just like this: name f_date s_date ----------------------------------------------- name3 2007-09-20 null name1 2007-10-01 null name2 2007-06-03 2007-10-07 any idea? use "select" query....maybe with 'UNION'? thanks in advance! artman --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
