>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 )