注册 登录
编程论坛 ACCESS论坛

菜鸟的提问.....

chanzj 发布于 2007-03-27 19:45, 1123 次点击
请问有这两个查询,怎么才能把他们的结果合在一起呢??
第一个是
SELECT RoleName, DeptName, Count(*) as numberOfSession
FROM Logons AS l, Events AS ev, Employees AS e
WHERE l.session_id=ev.session_id
And e.Name=l.name
And Result_Code=1
And Access_Type='S'
GROUP BY RoleName, DeptName;

第二个是
SELECT RoleName, DeptName, Count(*) as numberOfTable
FROM Logons AS l, Events AS ev, Employees AS e
WHERE l.session_id=ev.session_id
And e.Name=l.name
And Result_Code=1
And Access_Type='S'
GROUP BY RoleName, DeptName,TableName
我要的结果是在一个查询中同时显示numberOfSession和numberOfTable,请问要怎么做呢???
1 回复
#2
bygg2007-03-28 16:39
你这两个语句的结果不是一样的吗?
1