>I want to match two tables with the same checkno and acctno. So I do this,
>
>SELECT * FROM mds ;
> INNER JOIN acic ;
> ON mds.checkno+mds.acctno = mds.checkno+mds.acctno ;
> INTO CURSOR csr_Match
>
>but it doesn't give me the correct matched table..
>
>What's wrong?
Evelyn,
Where is the table acic in the join condition ?
If you do not have an index on checkno+acctno , try the following
select * ;
from mds ;
join acic ;
on ( mds.checkno = acic.checkno ) ;
and (mds.acctno = acic.acctno )
Gregory