Ordering rows by multiple coluimns

Branislav Vidovic

Hy! Here is the situation: I am interested in ordering rows in a returned querie (full outer join querie) and I need to do the ordering for 2 columns. Now, the thing is, simple ORDER BY can't help me. If you use

ORDER BY column1, column2

the result is sorting querie by column1 and then column2. This does not satisfy my situation. I wolud like sorting to be in a way that sorting happens for these 2 columns at once. I would like the result to look like this if it is possible:

column1 column2
25.5.1984 null
null 30.5.1985
null 17.5.1993
2.2.2005 null

The columns are type short date/time. Cheers!

Mycroft Holmes · column1 column2 25.5.1984 null null 30.5.1985 null 17.5.1993 2.2.2005 null

Try this

order by isnull(column1,column2)

Never underestimate the power of human stupidity RAH

Luc Pattyn

Nice one! :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Branislav Vidovic

Does not seem to help..

Luc Pattyn

I just happened to need this today, in MySQL though. There the function exists and is called ifnull. Works great. Thanks. :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.