这两句有区别吗,哪个好?
Select A.fielda1,B.fieldb1 From Table1 A Join Table2 B On A.fielda2=B.fieldb2 And A.fielda1='abcd'Select A.fielda1,B.fieldb1 From Table1 A Join Table2 B On A.fielda2=B.fieldb2
Where A.fielda1='abcd'
Select A.fielda1,B.fieldb1 From Table1 A Join Table2 B On A.fielda2=B.fieldb2 And A.fielda1='abcd'Select A.fielda1,B.fieldb1 From Table1 A Join Table2 B On A.fielda2=B.fieldb2
Where A.fielda1='abcd'
------
一个做表联接用,一个做数据筛选用
insert into @T1 select 1,'AAAA'
insert into @T1 select 2,'BBBB'
declare @T2 table(id int,name varchar(4))
insert into @T2 select 1,'CCCC'
insert into @T2 select 1,'DDDD'
insert into @T2 select 2,'EEEE'select * from @T1 a left join @T2 b on a.ID=b.ID and b.name='CCCC'
select * from @T1 a left join @T2 b on a.ID=b.ID where b.name='CCCC'