34,837
社区成员




select
SD.name, C.seid
from
SD inner join C
on SD.name = C.name
where
C.seid = 37
order by
SD.orderflag
declare @t table(name char(1),orderflag int)
insert @t select 'd',1
insert @t select 'c',2
insert @t select 'b',3
declare @tb table(name char(1),seid int)
insert @tb select 'b',37
insert @tb select 'c',37
insert @tb select 'd',37
select * from @tb
select b.*
from @tb b
left join @t a on a.name = b.name
order by a.orderflag
/*
name seid
---- -----------
b 37
c 37
d 37
(所影响的行数为 3 行)
name seid
---- -----------
d 37
c 37
b 37
(所影响的行数为 3 行)
*/