with allinsuredid as (
SELECT ii2.insuredid
FROM lcinsured ii, lccont c, lcinsured ii2
WHERE ii.contno = c.contno
and c.grpcontnxxxxx
and xxxxxxxxx
)
select * from allinsuredid ;
想了半天没想起来
with allinsuredid as (
SELECT ii2.insuredid
FROM lcinsured ii, lccont c, lcinsured ii2
WHERE ii.contno = c.contno
and c.grpcontnxxxxx
and xxxxxxxxx
)
select * from allinsuredid ;
想了半天没想起来