Join hints

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.