update B set B.G=A.G from A inner join B on A.Q=B.Qwhere A.W='广州' and A.E='牛肉' and A.R=''
upate bset b.g=a.gfrom A a inner join B b on a.Q=b.Q 其它一样