¼±ÇóÒ»¸ösqlÓï¾ä£¡£¡ - MS-SQL Server / »ù´¡Àà

ÓÐÕâÑùÒ»¸ö±í£¬wy_yslb,×Ö¶ÎÓÐyslb_id,yslb_cname,yslb_parentid,yslb_class,yslb_mjflg.Ò»¸öÊ÷Ðνṹ£¬yslb_mjflg = '1'¼´Îª×îÄ©¼¶¡£
ÀýÈ磺 yslb_id yslb_cname yslb_parentid yslb_class yslb_mjflg
  1 A 0 1 0
  2 BBB 0 1 0
  3 a 1 2 0
  4 aaa 3 3 1
  5 b 2 2 1
ÏÖÔÚ¸øyslb_mjflg = '1' µÄyslb£¬ÄÜÓÃÒ»¸ösqlÓï¾äµÃµ½ËûµÄÉϼ¶°üÀ¨Ëû±¾ÉíÂð£¿ÍûÖ¸½ÌϺÇ

---

SQL code:

--> ²âÊÔÊý¾Ý: #T1
if object_id('tempdb.dbo.#T1') is not null drop table #T1
create table #T1 (yslb_id int,yslb_cname varchar(3),yslb_parentid int,yslb_class int,yslb_mjflg int)
insert into #T1
select 1,'A',0,1,0 union all
select 2,'BBB',0,1,0 union all
select 3,'a',1,2,0 union all
select 4,'aaa',3,3,1 union all
select 5,'b',2,2,1

select * from #T1 where yslb_mjflg = '1'
union all
select * from #t1 where yslb_id in (select yslb_parentid from #T1 where yslb_mjflg = '1' )

yslb_id yslb_cname yslb_parentid yslb_class yslb_mjflg
----------- ---------- ------------- ----------- -----------
4 aaa 3 3 1
5