Select t1.Name ,(t1.InNum-t2.OutNum) as num from t1 left join t2 on t1.name=t2.name
select a.name,a.InNum-b.OutNum as num from t1 a left join t2 b on a.name=b.name
一句是写不出来了,不过这样也可以select tab1.tabname,tab1.tabcount-tab2.tabcount as count3 into tab3 from tab1,tab2 where tab1.tabname = tab2.tabname insert tab3 select * from tab1 where tab1.tabname not in (select tab2.tabname from tab2)select * from tab3
不用这么麻烦吧:) SELECT t1.name, innum - ISNULL(outnum, 0) as num FROM t1 LEFT JOIN t2 ON t1.nn = t2.nn
对不起,请把上面的nn改称nameSELECT t1.name, innum - ISNULL(outnum, 0) AS num FROM t1 LEFT JOIN t2 ON t1.name = t2.name
这个,适用于几乎所有数据库select t1.name, t1.InNum-t2.OutNum from t1,t2 where t1.name=t2.name union select name,InNum from t1 where name not in (select name from t2) ;
from t1 a
left join t2 b
on a.name=b.name
insert tab3 select * from tab1 where tab1.tabname not in (select tab2.tabname from tab2)select * from tab3
SELECT t1.name, innum - ISNULL(outnum, 0) as num
FROM t1 LEFT JOIN
t2 ON t1.nn = t2.nn
FROM t1 LEFT JOIN
t2 ON t1.name = t2.name
from t1,t2
where t1.name=t2.name
union
select name,InNum
from t1
where name not in (select name from t2)
;