>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

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