Hi all,

I am trying the following SQL command

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;
WHERE '01' $ LOWER(Clients.CompName) ;
OR 'hr' $ LOWER(PrsnDetl.Forename) ;
OR TotOrd = 300

The system gives me error that "variable TotOrd is not found". Any ideas, how I can use the column in my where clause.

Many thanks in advance,
Abhi