數據庫裡寫了一個存儲過程``
create proc dt_select
as
begin
select * from base1
where not exists(
SELECT * FROM base2 where
isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.實際完工,'')=isnull(base2.實際完工,'')
and isnull(base1.訂單品號,'')=isnull(base2.訂單品號,'')
and isnull(base1.產品品號,'')=isnull(base2.產品品號,'')
and isnull(base1.訂單單號,'')=isnull(base2.訂單單號,'')
and isnull(base1.訂單數量,'')=isnull(base2.訂單數量,'')
and isnull(base1.贈品量,'')=isnull(base2.贈品量,''))
end