Problem med SELECT fra flere tabeller i en SQL streng

Følgende giver fejl:

SQL = "SELECT Indikation FROM Relation,Indikationer,IndiLm WHERE Relation.IDdbSyg = " & SygdomID & " AND Relation.IDdbPreb = IndiLm.indi_LM AND IndiLm.IndiID_Indi = Indikationer.ID"

Fejl:
SELECT Indikation FROM
Relation,Indikationer,IndiLm
WHERE Relation.IDdbSyg = 1756
AND Relation.IDdbPreb =
IndiLm.indi_LM AND
IndiLm.IndiID_Indi =
Indikationer.ID

Microsoft OLE DB Provider for ODBC
Drivers error '80004005'

[Microsoft][ODBC Microsoft Access
97 Driver] Type mismatch in JOIN
expression.