In the previous article found here: Sage 100 2013 ODBC Help I went over the basic function of using SQL commands with a Sage 100 system. In this article I will go over the advanced feature including joins. The first join I will show is what Sage calls the Cross Join:

In needing to write a small program for my company access data from our Sage 100 ERP I found documentation lacking concerning writing SQL commands for the Sage 100 ODBC driver. Here are are some commands that I found useful when writing SQL statements for Sage 100.