问一个比较初级的Select语句 SELECT A.index , B.indexFROM DB.dbo.A, DB.dbo.BWhere A.index = B.index 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 同库的话dbo可去掉SELECT A.index , B.indexFROM A, BWhere A.index = B.index 试试这个:SELECT A.*, (select count(*) from B where A.index = B.index) as 'b表中的条数'FROM A select a.*,b.[条数] from a inner join (select index,count(1) [条数] from b group by index) b on a.index=b.index SELECT A.*, (select count(*) from B where A.index = B.index) as 'b表条数'FROM A SELECT A.*,C.条数 FROM A JOIN (SELECT *,ROW_NUMBER() OVER(PARTITION BY B.ID ORDER BY B.ID)AS 条数 FROM B)C ON A.INDEX=C.INDEX select a.*, isnull(b.qty,0) 'qty' from 表A a left join (select [index], count(1) 'qty' from 表B group by [index]) b on a.[index]=b.[index] select a.* from A a,B bwhere a.index = b.index sql查询难题目呀,不会了,请教大家 SQL2005修改数据库记录时不能添加中文? 讨论一下CSDN中给用户计分的数据库实现问题 将excel数据导入SQLServer时遇到的问题,请高手指教! a 表,b表问题 级联,是什么东西? 事务执行成功了。但是我打开数据库看。居然数据依然没有动。 join前加inner或full什么意,还有cross join 及TABLOCK, HOLDLOCK?及以下TABLOCK 用怎样的sql语句才能实现这样的功能???? 问个基本功问题。。。关于删除表内某行的 如何对比两个数据库中不同的字段 insert into 问题,请高手帮助下菜鸟
SELECT A.index , B.index
FROM A, B
Where A.index = B.index
SELECT A.*, (select count(*) from B where A.index = B.index) as 'b表中的条数'
FROM A
from a inner join (select index,count(1) [条数] from b group by index) b on a.index=b.index
FROM A
ON A.INDEX=C.INDEX
select a.*,
isnull(b.qty,0) 'qty'
from 表A a
left join (select [index],
count(1) 'qty'
from 表B
group by [index]) b on a.[index]=b.[index]
from A a,B b
where a.index = b.index