Update with join in Mysql

update ProbEnertag join ProbEner on ProbEner.id=ProbEnertag.probener_id set ProbEnertag.sign=3 where ProbEnertag.sign=0 and not (probe1<-2 and probe2<0.5>

This clause will set sign to 3, where ProbEner passes some filter and ProbEnertag.sign=0.