现有两个表Ta,Tb(问题不太好描述,进来看吧) select ta.m,case when tb.n is null then 0 else 1 end xyz from ta left join tb on ta.m=tb.n 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1:select ta.m,(case when tb.n is null then 0 else 1 end) as xyz from ta left join tb on ta.m=tb.n2:Select ta.m,(select count(*) from tb where n = ta.m) as xyzfrom ta Succeed!God bless you! varchar(n)和varchar(max)有什么区别,再是空间和效率上有差别么? 聊聊Mirror在实际应用中的问题-散分帖 [斑竹]删除MSXML 6 Service Pack2(KB973686)时报:安装时发生严重错误。 变量副值错误:( 非and语句的写法? [求助]sql语句求和统计 sql2005远程连sql2005的问题 触发器问题,请教 急寻对策!高分求救!!! sql server7数据复制问题 一个Excel文件包括三张表,怎么导到数据库中? 求教sql语句并散分
select ta.m,(case when tb.n is null then 0 else 1 end) as xyz
from ta left join tb on ta.m=tb.n2:
Select ta.m,(select count(*) from tb where n = ta.m) as xyz
from ta