search_condition

search_condition 
      ::= "as in sql select_command" 

[rule list]
This rule is call by

-> delete_statement -> simple_update -> subquery_update -> trigger_when