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