LOG table

userid	   action       time

18           login      556565686
14           logout     878787878
9            login      323232323

USER table

id username email                userid

9   ram     sample@sample.ocm     9
13  sunil   temp@temp.com         13
14  david   david@david.com       14
18  gopal   gopal@sample.com      18

========================================================================
Select * from USER INNER JOIN LOG ON USER.id = LOG.userid AND LOG.userid = 'login';

will result

id username email                userid

9   ram     sample@sample.ocm     9
18  gopal   gopal@sample.com      18


but i want

id username email                time

9   ram     sample@sample.ocm    323232323
18  gopal   gopal@sample.com     556565686





SELECT sysuser.id, sysuser.username, sysuser.email, sysuser.firstname, sysuser.lastname, sysuser.city, sysuser.country, sysuser.lastaccess, sysuser.confirmed, sysuser.mnethostid
                              FROM {$CFG->prefix}user
							  AS sysuser
							  INNER JOIN {$CFG->prefix}log
							  AS syslog
							  ON sysuser.id = syslog.userid
                              WHERE syslog.action = 'login'
							  AND $select $sort", $page, $recordsperpage