确实就应该是:select u1.Fdate,u1.fid,u2.price as price from a u1,b u2
where u1.fid=u2.fid order by u1.fdate,u1.fid desc Fdate是否还包含有时分秒的差异?
where u1.fid=u2.fid order by u1.fdate,u1.fid desc Fdate是否还包含有时分秒的差异?
调试欢乐多
u1.Fdate,u1.fid,u2.price as price
from
a u1,b u2
where
u1.fid=u2.fid
order by
convert(char(10),u1.fdate,120),u1.fid desc
where u1.fid=u2.fid
order by cast(u1.fdate as smalldatetime),u1.fid desc
select u1.Fdate,u1.fid,u2.price as price from a u1,b u2
where u1.fid=u2.fid order by u1.fdate desc 我刚才试一了一下这样也可以
select u1.Fdate,u1.fid,u2.price as price from a u1,b u2
where u1.fid=u2.fid order by u1.fdate desc,u1.fid desc
OK。解决。。来者都有分