1 message in com.mysql.lists.mysql-demysql subselect in selection
FromSent OnAttachments
Michael Borchers20 Sep 2006 02:25 
Subject:mysql subselect in selection
From:Michael Borchers (li@tridemail.de)
Date:09/20/2006 02:25:01 AM
List:com.mysql.lists.mysql-de

SELECT users.users_id, users.users_level

( SELECT max ( users_groups.level )

FROM users_groups, users2users_groups

WHERE users_groups.users_id = users.users_id

AND users_groups.users_groups_id = users_groups.users_groups_id ) AS group_level

FROM users

kann mysql 4.1 das "noch" nicht?!