Clarion Community Help

DRIVER('SQLDriver', '/USEINNERJOIN= TRUE | FALSE' )

[ Join“ = ] SEND(file, '/USEINNERJOIN [ = TRUE | FALSE ]' )

By default (USEINNERJOIN = True) the SQL Accelerator generates the following ANSI SQL for inner joins:

SELECT … FROM table1 INNER JOIN table2 ON table1.field=table2.field

However, not all backends support ANSI SQL. The driver provides an alternative syntax for inner joins. To generate the following alternative syntax, set USEINNERJOIN=FALSE:

SELECT … FROM table1, table2 WHERE table1.field=table2.field