navision --> SQL---> Lotus Notes

tbrendel

Hello, i try a SQL-funktion in Lotus NOtes to call fields from two tables
Job and Ressource.

from access the sql-statement that do the job is:

SELECT Jobplan.Job_No_, Ressource.No_
FROM Jobplan INNER JOIN REssource ON Jobplan.No_ = Ressource.No_


but from LOTUS NOTES, these SQL-Statement is empty...

WHY?

(from Lotus Notes an SQL-STATEMENT without INNER JOIN is fully functioning, but i need the second Table info)

Second try with an extra error handler gave me following information:
[Microsoft Corporation][Microsoft Business Solutions-Navision ODBC Driver] Unexpected extra token: JOIN

ok...third try: another sql-statement
qry.SQL = "SELECT Projektplan.[Projektnr.], Projektplan.Startdatum, Projektplan.Enddatum" &_
" FROM Projektplan, Ressource" &_
" WHERE (Projektplan.[Projektnr.] = Ressource.[Nr.])"

Error Handler: "Expected lexical token not found: FROM"
(i have tried these Statement in one line, but there is the same Error"