select b.产品名称,a.合同日期,a.供货单位,a.合同额,a.已付款,a.余额 into tmp from htidx a join ht b on a.id=b.id where 是否备件='是'
忘记into tmp表了select A.产品名称,B.合同日期,B.供货单位,B.合同额,B.已付款,(B.合同款-B.已付款) 余额 into tmp from ht A,ht_idx B where A.是否备件 ='是' AND A.id = B.id
select b.产品名称,a.合同日期,a.供货单位,a.合同额,a.已付款,(a.合同款-a.已付款) as 余额 into tmp from htidx a join ht b on a.id=b.id where 是否备件='是'
select A.产品名称,B.合同日期,B.供货单位,B.合同额,B.已付款,(B.合同款-B.已付款) 余额 from ht A right join ht_idx B on A.id = B.id where A.是否备件 ='是'
select ht.产品名称,ht_idx.合同日期,ht_idx.供货单位,ht_idx.合同额,ht_idx.已付款,(ht_idx.合同款-ht_idx.已付款) into temp from ht,ht_idx where ht.id=ht_idx.id and ht.是否备件='是'
select A.产品名称,B.合同日期,B.供货单位,B.合同额,B.已付款,(B.合同款-isnull(B.已付款,0)) 余额 from ht A left join ht_idx B on A.id = B.id where A.是否备件 ='是'还是:select A.产品名称,B.合同日期,B.供货单位,B.合同额,B.已付款,(B.合同款-isnull(B.已付款,0)) 余额 from ht A right join ht_idx B on A.id = B.id where A.是否备件 ='是'
select a.产品名称,b.合同日期,b.供货单位,b.合同额,b.已付款,余额=(b.合同额-a.已付款) into temp from ht a inner join ht_idx b on a.id=b.id where a.是否备件='是'
select a.产品名称,b.合同日期,b.供货单位,b.合同额,b.已付款,余额=(b.合同额-a.已付款) into temp from ht a inner join ht_idx b on a.id=b.id where a.是否备件='是'
可否能详细解释一下 left join right join inner join的区别?
select b.产品名称,a.合同日期,a.供货单位,a.合同额,a.已付款,a.余额 into tmp from htidx a join ht b on a.id=b.id where 是否备件='是'
select 产品名称,合同日期,供货单位,合同额,已付款,(合同额-已付款) as 余额 into tmp from ht,ht_idx where ht.id=ht_idx.id and 是否备件=是
into tmp from ht A,ht_idx B
where A.是否备件 ='是' AND A.id = B.id
from ht A right join ht_idx B on A.id = B.id
where A.是否备件 ='是'
from ht A left join ht_idx B on A.id = B.id
where A.是否备件 ='是'还是:select A.产品名称,B.合同日期,B.供货单位,B.合同额,B.已付款,(B.合同款-isnull(B.已付款,0)) 余额
from ht A right join ht_idx B on A.id = B.id
where A.是否备件 ='是'
into temp
from ht a inner join ht_idx b on a.id=b.id
where a.是否备件='是'
into temp
from ht a inner join ht_idx b on a.id=b.id
where a.是否备件='是'
from ht,ht_idx
where ht.id=ht_idx.id and 是否备件=是