fix the order of joined condition: it should replace the higher order
sub-condition