1 with xx as
(
(select t.*,rowid from xxb t where t.号码=('xxxxx') a
)//把查询结果放到临时表a中,以供全局使用
select m.*,rowid from xxb m where exists (select 1 from xx xx where m.唯一号=xx.唯一号;
1 with xx as
(
(select t.*,rowid from xxb t where t.号码=('xxxxx') a
)//把查询结果放到临时表a中,以供全局使用
select m.*,rowid from xxb m where exists (select 1 from xx xx where m.唯一号=xx.唯一号;