弱弱的问下inner join select * from A inner join B on xx=xx;和select * from A,B where xx=xx;有什么区别吗 最好能举个例子说明下在复杂点的应用里的区别 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 没有区别declare @t table (xx int,tt int)insert into @t values(1,14)insert into @t values(2,12)insert into @t values(3,16)insert into @t values(4,15)insert into @t values(5,14)insert into @t values(6,13)insert into @t values(7,12)insert into @t values(8,11)declare @b table (xx int,tb int)insert into @b values(1,114)insert into @b values(2,122)insert into @b values(3,156)insert into @b values(4,135)insert into @b values(5,174)insert into @b values(6,153)insert into @b values(7,182)insert into @b values(8,112)select * from @t t inner join @b b on t.xx=b.xxselect * from @t t ,@b b where t.xx= b.xx(1 row(s) affected)xx tt xx tb----------- ----------- ----------- -----------1 14 1 1142 12 2 1223 16 3 1564 15 4 1355 14 5 1746 13 6 1537 12 7 1828 11 8 112(8 row(s) affected)xx tt xx tb----------- ----------- ----------- -----------1 14 1 1142 12 2 1223 16 3 1564 15 4 1355 14 5 1746 13 6 1537 12 7 1828 11 8 112(8 row(s) affected) 微软的SQL SERVER联机丛书的理解。 MSSQL2008 EXPRESS 只能使用1G内存对IP20000的网站有多少影响? 关于链接服务器的问题. 急救~高手再不进来我就要打110,120,119救命了 询问!SQL Server (MSSQLSERVER) 服务因 17051 (0x429B) 服务性错误而停止。 **** 提交一个数万行的SQL语句去执行有杯具吗?! ***** 紧急求助!! 触发器影响到数据的删除,高手请教~~ sql语句的问题,急!急! 200分求助!关于中文笔画排序问题。 怎样写关于日期的SQL? 自动增加
insert into @t values(1,14)
insert into @t values(2,12)
insert into @t values(3,16)
insert into @t values(4,15)
insert into @t values(5,14)
insert into @t values(6,13)
insert into @t values(7,12)
insert into @t values(8,11)
declare @b table (xx int,tb int)
insert into @b values(1,114)
insert into @b values(2,122)
insert into @b values(3,156)
insert into @b values(4,135)
insert into @b values(5,174)
insert into @b values(6,153)
insert into @b values(7,182)
insert into @b values(8,112)
select * from @t t inner join @b b on t.xx=b.xx
select * from @t t ,@b b where t.xx= b.xx
(1 row(s) affected)
xx tt xx tb
----------- ----------- ----------- -----------
1 14 1 114
2 12 2 122
3 16 3 156
4 15 4 135
5 14 5 174
6 13 6 153
7 12 7 182
8 11 8 112(8 row(s) affected)xx tt xx tb
----------- ----------- ----------- -----------
1 14 1 114
2 12 2 122
3 16 3 156
4 15 4 135
5 14 5 174
6 13 6 153
7 12 7 182
8 11 8 112(8 row(s) affected)