Hi Huw, On Thu, 25 Oct 2007 01:15:44 am Huw Selley wrote: > Can you run that query yourself on your mysql server? At the very least you > should get an error telling you what mysql thinks is wrong with the query > which might help.
I ran the query on the database server itself and got the same error: ERROR 1054 (42S22): Unknown column 'Users_3.id' in 'on clause' If it take out: AND ( (CachedGroupMembers_2.MemberId = Users_3.id)) I don't get the error. Could it be that using Users_3 before it is defined in the following statement (Users as Users_3 WHERE ) is causing the problem? Kind regards, Geoff -- ___________________________________ From the desk of Geoff Roberts Implementation Partner AUSTRALIAN PROJECTS PTY LIMITED S A F E K N O W L E D G E IT Security - Data Protection Email: [EMAIL PROTECTED] Mobile: 0416 210 111 NATIONAL HELP DESK SUPPORT Sydney 02 4231 4222 Melbourne 03 9017 8222 Adelaide 08 6461 6222 Perth 08 8463 1222 Brisbane 07 3137 1555 Hobart 03 6281 2555 Canberra 02 6112 8855 ___________________________________ _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
