Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement....
Message
From
18/06/1999 16:06:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL Statement....
Miscellaneous
Thread ID:
00231575
Message ID:
00231575
Views:
39
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
Next
Reply
Map
View

Click here to load this message in the networking platform