with dc as
(
select a.* from sfa_t_TSysDictionary a
where a.RowID =1
union all
select b.* from sfa_t_TSysDictionary b
inner join dc on b.PRowID=dc.RowID
)
select * from dc order by PRowID
with dc as
(
select a.* from sfa_t_TSysDictionary a
where a.RowID =1
union all
select b.* from sfa_t_TSysDictionary b
inner join dc on b.PRowID=dc.RowID
)
select * from dc order by PRowID
转载于:https://my.oschina.net/xingtao/blog/284401