The OpenAccess SDK SQL engine syntax includes specification of the preferred processing order as a HINT at the end of the SELECT statement.
• HINT JOIN QUERY ORDER
• HINT JOIN (tablex, tabley, tablez)
Example
SELECT * FROM emp, dept
WHERE empno = 1 AND emp.deptno = dept.deptno HINT JOIN QUERY ORDER
SELECT * FROM emp, dept
WHERE empno = 1 AND emp.deptno = dept.deptno HINT JOIN (emp, dept)
Note: When using applications, such as Microsoft Excel, that support the use of wizards for creating SQL queries, you must manually edit the query to append the HINT clause.
Note: All the tables used in a join must be specified in the HINT JOIN clause. Otherwise, the HINT will be ignored.
