select ACBL into #aaa from RD0 where ACIT='2110101'and
ACDT='20070630'and BRNO='0101'
select ACBL into #bbb from RD0 where ACIT='21101'and
ACDT='20070630'and BRNO='0101'
select #bbb.ACBL - #aaa.ACBL
请问下为什么临时表的#bbb.ACBL不能减#aaa.ACBL呢``?该怎么写``
ACDT='20070630'and BRNO='0101'
select ACBL into #bbb from RD0 where ACIT='21101'and
ACDT='20070630'and BRNO='0101'
select #bbb.ACBL - #aaa.ACBL
请问下为什么临时表的#bbb.ACBL不能减#aaa.ACBL呢``?该怎么写``
from #bbb b, #aaa a