select * from xiaolin_erp_pan
for update
delete xiaolin_erp_pan
select liao,cang,chu,pi,qty,(select ima01 from ima_file where imaud01 = liao and imaacti = 'Y') from xiaolin_erp_pan
delete xiaolin_erp_pan where liao in (select liao2 from xiaolin2)
with ttt as
( select imaud01,count(ima01) t from ima_file
where imaud01 in (select liao from xiaolin_erp_pan)
and imaacti = 'Y'
group by imaud01
)
select imaud01,t from ttt where t>1
create table xiaolin2(
liao2 varchar(100) not null
);
select * from xiaolin2
for update
delete xiaolin2
with 表名 as 用法
最新推荐文章于 2024-04-25 15:31:43 发布