菜鸟的提问.....
请问有这两个查询,怎么才能把他们的结果合在一起呢??<BR>第一个是<BR>SELECT RoleName, DeptName, Count(*) as numberOfSession<BR>FROM Logons AS l, Events AS ev, Employees AS e<BR>WHERE l.session_id=ev.session_id<BR>And e.Name=l.name<BR>And Result_Code=1<BR>And Access_Type='S'<BR>GROUP BY RoleName, DeptName;<BR><BR>第二个是<BR>SELECT RoleName, DeptName, Count(*) as numberOfTable<BR>FROM Logons AS l, Events AS ev, Employees AS e<BR>WHERE l.session_id=ev.session_id<BR>And e.Name=l.name<BR>And Result_Code=1<BR>And Access_Type='S'<BR>GROUP BY RoleName, DeptName,TableName<BR>我要的结果是在一个查询中同时显示numberOfSession和numberOfTable,请问要怎么做呢??? 你这两个语句的结果不是一样的吗？页:
[1]