LEFT OUTER JOIN using C/ODBC Naviison 3.70

Posted: Thu Apr 15, 2004 9:35 am Post subject: How to perform a LEFT OUTER JOIN in C/ODBC Navision 3.10 -------------------------------------------------------------------------------- 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?