YUKAI/导入/sql_20151229...

use YK_CarLoan
select * from T_YW_BusinessBase where F_InstanceId=0 order by F_BusinessId desc

select * from T_YW_BusinessDetail where F_BusinessId in (select F_BusinessId from T_YW_BusinessBase where F_InstanceId=0)

select * from T_Cus_LinkMan where F_BusinessId in (select F_BusinessId from T_YW_BusinessBase where F_InstanceId=0)

select * from T_YW_FileInfo

select * from T_Sys_UserAccount 

select * from T_Sys_RegionCategory where F_RegionName like '%%' and F_ParentId

--delete from T_YW_BusinessBase where F_InstanceId=0 

--delete from T_YW_BusinessDetail where F_BusinessId in (select F_BusinessId from T_YW_BusinessBase where F_InstanceId=0)

--delete from T_Cus_LinkMan where F_BusinessId in (select F_BusinessId from T_YW_BusinessBase where F_InstanceId=0)