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/my***********...ie.nctu.edu.tw 
