看看以上的sql語句怎麼樣

select a.Column_ID,a.Parent_ID,Fathers_ID,b.bs_id,ss_id from newview a,oldview b where a.Column_Name=b.ss_name and ss_id not in(select distinct ss_id from newview a,oldview b where a.Column_Name=b.ss_name and (Column_Name='其他未分類' or Column_Name='其他')) and ss_id not in(select ss_id from oldview where ss_id in(select ss_id from (select count(*) aa,ss_id from (select top 100 percent a.Column_Name,a.Column_ID,a.Parent_ID,Parent_Name,Fathers_ID,ss_id,ss_name,b.bs_id,bs_name from newview a,oldview b where a.Column_Name=b.ss_name and Column_Name<>'其他未分類' and Column_Name<>'其他') t group by ss_id) tab where aa>1))

 

對外承接sql語句編寫和新資料舊資料的匯入

對外承接sql語句編寫和新資料舊資料的匯入

看看以上的sql語句怎麼樣