Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement....
Message
De
18/06/1999 16:12:07
 
 
À
18/06/1999 16:06:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00231575
Message ID:
00231581
Vues:
16
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


You have two AND statements together on the third to last line.
Stephen Kuhn

Prism Network, Inc.
System Developer

At last we can reveal ourselves to the Jedi.
At last we will have revenge.
-Darth Maul
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform