简单的SQL

stef

1、SELECT jfdm AS code, xzqm+jdmc+jfmc AS name INTO vl
FROM power;

2、都有的
SELECT a.code,b.code,b.name into 都有的 from vj as a,vl as b where a.name =b.name ;
3、SELECT a.code, a.name INTO 土地有经管无
FROM vl AS a
WHERE a.name not in (select b.name from vj b);

4、SELECT a.code, a.name INTO 经管土地对不上的
FROM vj AS a
WHERE a.name not in (select b.name from 都有的 b);

wwxx

谢谢分享！！！！

359732265

进来看看，学习学习

pf1996

谢谢分享！！！

lyll610610

11111111111111