SQL基础语句

删除关联关系处理数据库

select *  from T_BF_INSTANCEENTRY where 1=1 and FSTABLENAME ='t_PUR_POOrderEntry'

and fttablename='CGDD002629'

and FSID  in (select fentryid from  T_PUR_POORDER a 

inner join T_PUR_POORDERENTRY b on b.fid = a.fid  where a.FBILLNO='CGDD002629')

--查询

select *  from T_BF_INSTANCEENTRY where 1=1 and FSTABLENAME ='t_PUR_POOrderEntry'and

 FTTABLENAME ='T_AP_PAYABLEENTRY'and FSID  in (select fentryid from  T_PUR_POORDER a 

 inner join T_PUR_POORDERENTRY b on b.fid = a.fid  where a.FBILLNO='cgdd002629')

--备份

select * into T_BF_INSTANCEENTRY_sqlbak_20230613 from T_BF_INSTANCEENTRY;

--更新

delete  T_BF_INSTANCEENTRY where 1=1 and FSTABLENAME ='t_PUR_POOrderEntry'and FTTABLENAME ='T_AP_PAYABLEENTRY'and 

FSID  in (select fentryid from  T_PUR_POORDER a inner join T_PUR_POORDERENTRY b on b.fid = a.fid  

where a.FBILLNO='cgdd002629')