hi
i'm am trying to use the following

INSERT INTO phplog_members (userid, groupid)
SELECT u.userid, g.groupid
FROM phplog_users u,phplog_groups g
WHERE u.username="interactive test" AND g.groupname="annual"

when i use mysqlcc to check the script it works fine, when i enter the script into the software i use (email2db) it comes back with

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 NativeError: 1064

yet i am using the exact same database which is version 4.0.23a

is this because the version of mysql is wrong or the 3rd party software

kenny