found the problem, it should be 'select p.acctno...'

--- In firebird-support@yahoogroups.com, "wang960" <wang960@y...> wrote:
> hi,
>
> if I do a 'select acctno from cvpmt', everything is ok, but if do:
> 'select acctno from cvpmt p, account a where p.acctno = a.acctno'
> I got an error:
>
> Dynamic SQL Error.
> SQL error code = -204.
> internal gds software consistency check (table CVPMT).
> ACCTNO.
>
> but if i tried the above in IB6, no error at all, why?
>
> thanks,
>
> Frank