noyearzero - 3:02 pm on Jun 19, 2012 (gmt 0)
I'm not sure if this is exactly right....but it should put you on the path. (replace `tbl_access_log.id` with the actual primary index for the table `tbl_access_log`)
LEFT JOIN tbl_access_log ON tbl_access_log.id = (
tbl_access_log.fld_user_id = '" . $adminId . "'
Additionally, if your $adminId variable actually refers to the current row in the outer table (tbl_admin_users) you could replace
'" . $adminId . "'
(assuming fld_user_id is the name of the same field)
That would be more appropriate if your outer table is meant to pull back more than 1 row