Kevin,

One thing no one else has mentioned is that you are using "a" as an alias for your Suspend table. Single letters a - j are also used to refer to the first 10 work areas. Stay away from m also since that's for memory variables.

Try using a few more letters.



>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