However, when I'm in the mysql command line prompt and type something like
delete from team left join user on( team.id=user.team_id ) where user.team_id is nullI get a syntax error, and so I believe that there will be grief were I to try
Team::model()->deleteAll( array( 'join'=>'left join user on team.id=user.team_id', 'condition'=>'user.team_id is null' ));even though one would think that should be legal.
I believe that the code in createDeleteCommand needs to be changed to also include the table name between the DELETE and the FROM, so that the resulting SQL will read
DELETE team FROM team left join....