这个句子如何该？

[delwin]

SELECT @id=Max(id),@dt_address=a.dt_address
fROM WORK_DATADAY a,dt_user b
where a.dt_address=b.dt_address
group by a.dt_address ;

Select @Counts=Count(M.ID)
From (Select a.ID,a.DT_Address,a.Code_Str,b.IP_Port
From Work_Dataday a,DT_User b
Where a.Con_Nect<>3 And a.DT_Address=b.DT_Address
And b.Login=1
) M
Where (Select Count(*)
From (Select a.ID,a.DT_Address,a.Code_Str,b.IP_Port
From Work_Dataday a,DT_User b
Where a.Con_Nect<>3 And a.DT_Address=b.DT_Address
And b.Login=1
) N
Where N.Dt_Address=M.Dt_Address And N.Id<=M.Id)=Cnnt And M.id=@Id and m.dt_address=@dt_addresss ;

我想把上面这两句改为一句如何改？

[netcoder]

不了解表结构，不了解你想要实现的功能