update tableB, tableA set tableB.status='equals' where tableB.id=tableA.id and tableA.age = tableB.age;update tableB, tableA set tableB.status='add' where tableB.id=tableA.id and tableA.age > tableB.age;update tableB, tableA set tableB.status='minus' where tableB.id=tableA.id and tableA.age < tableB.age;update tableB, tableA set tableB.status='lost' where tableB.id not in (select distinct id from tableA)
where tableB.id=tableA.id and tableA.age = tableB.age;update tableB, tableA set tableB.status='add'
where tableB.id=tableA.id and tableA.age > tableB.age;update tableB, tableA set tableB.status='minus'
where tableB.id=tableA.id and tableA.age < tableB.age;update tableB, tableA set tableB.status='lost'
where tableB.id not in (select distinct id from tableA)
谢谢哈~ 运行ok 就是要这个效果 以前不知道update还可以同时选择两个table呢