DB2的with
with temptable(COMCODE,UPPERCOMCODE,Validstatus)as
(select root.COMCODE,root.UPPERCOMCODE,root.Validstatus
from PRPDCOMPANY root where root.COMCODE=''
union all
select sub.COMCODE,sub.UPPERCOMCODE,sub.Validstatus
from
PRPDCOMPANY sub,
temptable super
where sub.UPPERCOMCODE=super.comcode
and sub.comcode<>super.UpperComCode
and sub.Validstatus = '1')
select COMCODE from temptableORDER BY ComCode
页:
[1]