this query:
SELECT sentmails.[VersandDatum],
sentmails.[DatumMailGeplant],
mailintervals.[Interval],
definitions.[Subject],
users.[Name],
sentmails.[MailArt],
Objekte.[Name],
sentmails.[Erledigt],
sentmails.[ID]
FROM Objekte
RIGHT JOIN (users RIGHT JOIN (definitions RIGHT JOIN (mailintervals RIGHT JOIN (sentmails) ON mailintervals.ID=sentmails.Intervall) ON definitions.ID=sentmails.Noti_ID) ON users.UID=sentmails.Funktion) ON Objekte.OId=sentmails.Objekt_ID
...works fine in ms access qbe, but in sql server it returns a "incorrect syntax near ')'" error. I'm really wondering why:
- the joins need to be in brackets?
- no more outer joins in sql server?
- somewhere more brackets needed?