>Morning all
>
>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
>
>Thanks
>Kev


Kevin, which service pack do you have installed. Make sure that you have at least service pack 3 installed as this will reduce the number of fatal exception errors.

Mace