问题呀~~~迷雾呀~~在线等呀!!!!!!
我在运行的时候,说GO附近有语句错误,可是这个是刚从别人那里拷贝过来的
而且运行的还很好,求指教~~~~~
if exists (select name from sysobjects where name='customer_order')
drop table customer_order
go
select dd.contract_number,dd.contract_id , dd.account_id , dd1.cntrt_refid03,
dd.contract_start_date,dd.cntrt_date07,dd.contract_type ,
dd.cntrt_int23,dd.cntrt_int24,dd.contract_amount
into customer_order
from tc_contract dd inner join tc_contract_attr dd1 on dd.contract_id = dd1.contract_id
where dd.org_id = 1 and dd1.org_id = 1