PF.........ONDE ESTA O ERRO

 

sql_innerjoinGri = "SELECT EX.*, REQ.* FROM TB_EXAMES AS EX INNER JOIN TB_REQUISICOES AS REQ ON EX.REQEXCOD=REQ.REQEXCOD AND EX.REQCOD=REQ.REQCOD "
sql_innerjoinGri = sql_innerjoinGri & "AND REQ.REQDTENTRAD >= '" & Format(CDate(d1), "YYYY/MM/DD") & "'   AND REQ.REQDTENTRAD <= '" & Format(CDate(d2), "YYYY/MM/DD") & "' "
sql_innerjoinGri = sql_innerjoinGri & "AND EX.EXSTATUS = STR ('MA')"

 

A MSG DE ERRO É:

 

RUN-TIME ERROR '3296'

SEM SUPORTE PARA A EXPRESSÃO DE ASSOCIAÇÃO

falta o where

 

SELECT
 EX.*,
 REQ.*
FROM TB_EXAMES AS EX
INNER JOIN TB_REQUISICOES AS REQ ON EX.REQEXCOD=REQ.REQEXCOD AND EX.REQCOD=REQ.REQCOD
WHERE
REQ.REQDTENTRAD >= '2005/01/01'  
AND REQ.REQDTENTRAD <= '2005/01/01'
AND EX.EXSTATUS = 'MA'
 

muito obrigado!!!!!!!!!!