order by

[nelco]

I have a table which has several columns among which the column I am interested is called name. The rows for this column refers to people who have joint account and looks something as follows(firstperson/secondperson:

Nancy/Roy
Adam/Drew
Nancy/Roy
Nick/Jessica
Drew/Adam
Joe/Sam
Adam/Drew
Sam/Joe

I want to order the rows based on same joint account names (keeping in mind first and last names are same as last and first name. example: Adam/Drew and Drew/Adam):
Output should be as follows in order by clause

Adam/Drew
Adam/Drew
Drew/Adam
Joe/Sam
Sam/Joe
Nancy/Roy
Nancy/Roy
Nick/Jessica

Any help /logic will be appreciated

 

[r937]

see thread183-1492977

r937.com | rudy.ca