Posted on: 03/21/06 12:50pm
By: lguhr
tis 21 mar 2006 18.17.17 - 1054: Unknown column 'gl_users.uid' in 'on clause'. SQL in question: SELECT DISTINCT gl_users.uid,username,fullname,email,photo,regdate,lastlogin FROM gl_users,gl_group_assignments LEFT JOIN gl_userinfo ON gl_users.uid=gl_userinfo.uid WHERE gl_users.uid > 1 AND gl_users.uid = gl_group_assignments.ug_uid AND (gl_group_assignments.ug_main_grp_id IN (4,1)) ORDER BY username asc ;
Posted on: 03/21/06 06:15pm
By: Dirk