Board index » delphi » BDE Probem, HAVING doesn't work

BDE Probem, HAVING doesn't work

I have 2 tables :
pfe(nopfe,name,nbetumax(integer),...)
eleveif(noeleve,nopfe(foreign key),...)

this select with HAVING doesn't work correctly?

select el1."NOPFE",pfe."nbetumax",count(el1."NOPFE")
  from  "\\servif1\pfe\pfeif\eleveif.dbf" as el1,
          "\\servif1\pfe\pfeif\pfe.dbf" as pfe
  where el1."NOPFE"= pfe."NOPFE"
  group by el1."NOPFE",pfe."nbetumax"
  having pfe."nbetumax"=count(el1."NOPFE")

I use BDE 4.51

Thanks for help
J-F Petit

--
<x-rich>--

* <bold>Jean-Francois PEtit      </bold>E-mail :
Jean-Francois.Pe...@if.insa-lyon.fr *

*                 <bold>I.N.S.A. LYON   Departement Informatique          
  </bold>*

*    L3I   Laboratoire d'Ingenierie de l'Informatique Industrielle      *

* Bat. 502 20, avenue Albert Einstein   Tl/Phone : (33/0)4 72 43 83 75 *

* F-69621 VILLEURBANNE CEDEX  FRANCE          Fax : (33/0)4 72 43 85 18
*</x-rich>

 

Re:BDE Probem, HAVING doesn't work


What Database are you using?  What is the error you are getting?
********************************
Michael Glatz
glatzfa...@aol.com
mgl...@briefcase.com

Other Threads