How to perform a LEFT OUTER JOIN in C/ODBC Navision 3.10

Johan_van_Bragt

I want to perform the following query:
SELECT sc.Code as code, sc.Description as Naam, jt.Type
FROM "Source Code" as sc
LEFT OUTER JOIN "Gen_ Journal Template" as jt on jt."Source Code"=sc.Code

C/ODBC does not support the LEFT OUTER JOIN syntax. Therefore i reconstructed the query to:

SELECT sc.Code as code, sc.Description as Naam, jt.Type
FROM "Source Code" as sc, "Gen_ Journal Template" as jt
WHERE jt."Source Code" = sc.Code

The problem is that this is an INNER JOIN and i loose records this way...
How do i specify a LEFT OUTER JOIN?