Hi Sergey,

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