DataAdapter select statment error

[Totto]

Hi all,
Can anyone tell me why I get an error trying to use
this select statement with an Dataadapter:

SELECT Dokument.Navn, Dokument.Path, Dokument.Utlopsdato,
Dokument.Triggefor, DokumentType.TypeTekst, Omraade.Navn
FROM Omraade INNER JOIN (DokumentType INNER JOIN Dokument ON
DokumentType.DokumentTypeID = Dokument.DokumentTypeID) ON Omraade.OmraadeID
= Dokument.OmraadeId

It works in Access.

TNX
Totto

 

[EMW]

Maybe you must use LIKE instead of =

hope this helps.
Eric