求一句SQL 在同一张表里把两个时间字段联合查询

[Leon_s_kennedy]

原表A

ID NAME TEL INTIME OUTTIME
---------------------------------------------
1 a 123 2011-1-1
2 b 234 2011-5-5
3 c 345 2011-3-3
4 d 456 2011-4-4
5 e 567 2011-2-2

结果
ID NAME TEL TIME
---------------------------------
1 a 123 2011-1-1
5 e 567 2011-2-2
3 c 345 2011-3-3
4 d 456 2011-4-4
2 b 234 2011-5-5

[jiangzhong610]

order by 排序

SELECT ID,Name,Tel,INTime AS Time
FROM [Table]
ORDER BY INTime 

[老潘]

SELECT ID,Name,Tel,ISNULL(INTime,OutTime) AS Time
FROM [Table]
ORDER BY Time

[cd731107]

select ID,NAME,TEL,INTIME as [TIME]
from a
order by [time]

[AcHerat]

select ID,NAME,TEL,INTIME as [TIME]
from a
order by INTIME 

[chuanzhang5687]

select ID,NAME,TEL,INTIME as TIME
from a
order by time

[chuanzhang5687]

select ID,NAME,TEL,INTIME as TIME
from a
order by time

[yubofighting]

没看懂LZ的意思，原表OUTTIME字段有值吗？

[xiaoxiao8372]

完全没看明白！！

[--小F--]

order by INTIME ?