I haven't seen anyone answer this, so here goes - try adding the group by
statement. Also, indicate what you really want from the log_userstatus
table. If all you want is the date, just select that (and add it to the
group by clause).
SELECT
teaserusers.userid,
teaserusers.nickname,
teaserusers.firstname,
teaserusers.lastnames,
teaserusers.email,
teaserusers.registereddate,
log_userstatus.*
FROM teaserusers LEFT JOIN log_userstatus
ON teaserusers.userid = log_userstatus.userid
GROUP BY teaserusers.userid,
teaserusers.nickname,
teaserusers.firstname,
teaserusers.lastnames,
teaserusers.email,
teaserusers.registereddate,
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
