Help with Query!

[Bernini]

Hi

I have the following query which retrives the total and percentages of access users had on my site (restricted).

SELECT concat(U.surname, ' ', U.name) as UNAME, C.name as CNAME,
count(S.ID) as Total,
((count(S.ID) / (select count(ID) from usr_session_log) )*  100 ) as PERC
FROM `usr_session_log` S
left outer join usr_users U on U.ID = S.user_id
left outer join usr_company C ON C.ID = U.company
group by UNAME, LDATE
Order by PERC DESC

The above works well!

Now i would like to add the latest IP used per user and the lastest date the user accessed the site!

How can i implement this with out sending the whole query haywire?

Thanks
B

 

[esdee]

may be something like:

select ip, date from table where
date = (select max(date) where user = userid)
and user = userid

with respective changes for your context

------------------------
dev at viewmoresoft.com

http://www.viewmoresoft.com

tools for your database

 

[r937]

the above works well? how is that possible, since you are grouping on a column (LDATE) that isn't mentioned anywhere in the query

which table contains the user's IP?

which table contains the date the user accessed the site?



rudy

http://r937.com/

SQL Consulting

 

[SPrelewicz]

esdee's solution seemed to work for a similar problemi had.

http://www.flyingroman.com/_about_me

About me at Flying Roman.com lyric meaning and discussion

http://www.scottprelewicz.comScott

Prelewic, Renassance Man