Kev,

This error can happen if you have a corrupted index or table.

>
>I have tried to run the SELECT below but get a Fatal Exception error, any ideas?
>
>sele poline.*,suspend.su_stdt;
>from poline left outer join suspend;
> on poline.pl_ref = suspend.pl_ref;
> and suspend.su_susstop = "N" ;
>wher suspend.su_stdt = (sele min(su_stdt) from suspend a where a.pl_ref = suspend.pl_ref);
> or isnull(suspend.su_stdt);
>orde by poline.pl_ref,suspend.su_stdt