Have you tried removing the brackets ( ) from around the fields in the SELECT part of the query?
I did as you suggested and ran the query without brackets, and it worked perfectly.
Thank you for the speedy and helpful advice! Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]