On Thu, 2003-07-24 at 11:58, mixo wrote: > 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 > ++++++++++++++++++++
Try: SELECT groupmembers.memberid, users.name FROM groupmembers, users, groups WHERE users.name<>'root' AND groupmembers.groupid=groups.id AND groups.type='Privileged' AND groupmembers.memberid=users.id ORDER BY name > And, it it possible to remove the case sensetivity of table names. Read the first item that appears in MySQL manual if you search for "case sensitivity": http://www.mysql.com/doc/en/Name_case_sensitivity.html -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
