Yes, I already corrected it in another message to you.

>Many thanks for your help. However to get all the records matching my criteria, I removed the table reference from where clause of forename.

>SELECT * FROM ( ;
>	SELECT Id, Forename, Compname, SUM(OrdTotal) TotOrd ;
>		FROM clients ;
>			LEFT JOIN Prsndetl ON Clients.Id = PrsnDetl.ClientId ;
>			LEFT JOIN Orders ON Clients.Id = Orders.ClientId ;
>		GROUP BY Clients.Id, Clients.Compname, PrsnDetl.Forename ) dt1;
>  WHERE '01' $ CompName ;
>  OR 'hr' $ LOWER(Forename) ;
>  OR TotOrd = 300