ODBC OUTER JOINS

This is a question about ODBC and OUTER JOINS Does ODBC delivered with Navision 2.60a execute OUTER JOINS? In msSQL a want to make an outer join on my tables in navision 2.60a. But this doesn’t work.

The ODBC driver will not support an outer join. It’s not clear if this is a SQL Navision database or if you’re attempting to access a Navision database from SQL, but if it’s SQL, you should be able to configure a OLE DB driver for SQL server and make it work. Allen Beck President Beck Consulting Alameda, CA & Bellevue, WA allen@beckconsulting.com 800-456-8474