求高手帮我把这2条SQL语句并起来，在线等！！
select t.login_name,t.login_date,y.full_name,y.department_name from tb20100925 t ,yhqx y
where t.login_name(+) = y.login_name


select login_name,count(*) from (
select login_name ,login_date from tb20100925
group by login_name,login_date)
group by login_name




tb20100925 有login_name，login_date，字段
yhqx 有 login_name，full_name，department_name 字段
我现在要抽出每个用户从9月1号到30一共登入了几次但不包括每天登陆的次数，还要附加全名和部门名
这个是我写的，不行。谁能帮下啊


select t.login_name,count(*), y.full_name,y.department_name from yhqx y
(select t.login_name,count(*) from
(
select login_name ,login_date from tb20100925
group by login_name,login_date)
group by login_name) t
where t.login_name(+) = y.login_name

[解决办法]
楼主能花一分钟看一下这个贴子吗？

http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html

[解决办法]
select A.login_name,B.full_name,B.department_name,A.QTY
FROM
(
select login_name,count(*) as QTY
from tb20100925
where login_date between '2010-09-01' and　'2010-09-25'
group by login_name
) as A inner join yhqx as b on A.login_name=B.login_name