I got this:

Quote
select t2.USER_REAL_EMAIL from ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3 where t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t4.GROUP_ID IN (33) and t4.GROUP_ID IN (33) and t4.GROUP_ID IN (33)GROUP BY t1.USER_ID ORDER BY t1.USER_DISPLAY_NAME ASC

Unknown table 't4' in where clause

Last edited by Rick; 10/19/2006 11:53 AM.