Something similar is available using a FROM clause instead of a SELECT clause, but it is only available in mysql 4.0.
Fred Andy <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I am trying to do a combination of SQL statements like described in a SQL > bóok. Is it possible, that mysql does not allow this syntax? > > Thanx Andy > > Error: > > Occured during executing DELETE FROM test_user_interests WHERE user_id = > (SELECT user_id FROM test_user WHERE user_name = 'herbert01') statement > > Error: 1064 You have an error in your SQL syntax near 'SELECT user_id FROM > test_user WHERE user_name = 'herbert01') ' at line 3 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]