一个是次数列表(每天访问一次Num+1) UserID Day Num 1 2009-09-22 10 2 2009-09-22 20 4 2009-09-22 8
想要的结果是 2 20 1 10 4 8 3 0
需要按访问次数来排列，但是直接用访问次数表来查询的话，可能有些用户没数据。该如何写查询语句呢？SQL code: select t2.* from t1 left join t2 on t1.userid = t2.userid order by t2.num desc
num列查出来的值是NULL的你自己再处理下就可以了。 2楼的基础上加上排序的就可以了. select a.UserId as Userid,isnull(b.Num,0) as Num from 用户列表 as a left join 次数列表 as b on a.UserId=b.UserId order by b.Num desc 顶这个 如果想输出 用户表 的其他字段 该怎么改一下呢？ 搞定了，select a.UserId as Userid,isnull(b.Num,0) as Num a.* from 用户列表 as a left join 次数列表 as b on a.UserId=b.UserId 就可以了，谢谢了啊
请教一下：我用vb写了一个调用Illustrator的测试程序，代码很简单：Private Sub Command1_Click() Dim app As New Illustrator.Application Dim doc As Illustrator.Document Dim thislayer As Illustrator.Layer ......
Private Sub Check1_Click() If Check1.Value = 1 Then DTP1.Enabled = True Else DTP1.Enabled = False End If End Sub Private Sub Check2_Click() If Check2.Value = 1 Then DTP2.Enabled = True Else
......
