How can I write this query so it works on mysql 3.54:
++++++++++++++++++++
select groupmembers.memberid,users.name from groupmembers,users where (not users.name='root')
and groupmembers.groupid=(select groups.id from groups where groups.type='Privileged')
and groupmembers.memberid=users.id
order by name
++++++++++++++++++++
And, it it possible to remove the case sensetivity of table names.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
