Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement....
Message
De
18/06/1999 16:06:12
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL Statement....
Divers
Thread ID:
00231575
Message ID:
00231575
Vues:
40
Can anyone tell me what's wrong with this sql statement? I keep getting the error message Function name missing )

SELECT DISTINCT TMPLAB.ID, TMPREG.DOB, TMPINF.LIVRSKB ;
FROM TMPREG, TMPINF, TMPLAB ;
WHERE TMPLAB.ID = TMPREG.ID ;
AND (TMPINF.LIVRSKB = .F. AND TMPINF.HEPBVACC = .F. AND TMPLAB.AHBS = 'P' AND TMPLAB.AHBC = 'P') ;
AND (TMPLAB.LABIMPDATE >= M.DATE1 AND TMPLAB.LABIMPDATE <= M.DATE2) ;
UNION ;
SELECT DISTINCT TMPLAB.ID, TMPREG.DOB, TMPINF.LIVRSKB ;
FROM TMPREG, TMPINF, TMPLAB ;
WHERE TMPLAB.ID = TMPREG.ID ;
AND (TMPINF.LIVRSKC = .F. AND AND TMPLAB.AHCV = 'P' AND TMPLAB.AHCVQ > 3) ;
AND (TMPLAB.LABIMPDATE >= M.DATE1 AND TMPLAB.LABIMPDATE <= M.DATE2) ;
INTO TABLE C:\HESDRA\HEPC
Thanks in Advance.

J. Turner
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform