| **Navigation:**  SQL Drivers > Oracle >====== WHERE ====== | [[useasynchronouscalls oracle.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[oracle accelerator driver properties.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

In addition to WHERE driver string supported by all the SQL Accelerator drivers, Oracle Accelerator supports the following special WHERE driver string.

__**/Where in the FILE Definition**__

When a FILE declaration references more than one Oracle table, you must tell the Oracle server which columns link the tables together. A /WHERE in the FILE definition specifies the connecting fields between two or more Oracle tables. For example:

**OrdBrowse FILE,DRIVER('ORACLE','/WHERE Orders.AccNum=Customer.AccNum'),|**

**          NAME('Orders,Customer'),PRE(Orb),BINDABLE,THREAD**

** OrdbKey  KEY(-Orb:OrderNumber),NAME('OrdbKey'),PRIMARY**

** Record       RECORD,PRE()**

** OrderNumber   LONG,NAME('OrderNum')**

** AccountNumber LONG,NAME('Orders.AccNum')**

** ShipTo        STRING(32),NAME('ShipTo')**

** Name          STRING(31),NAME('Name')**

**              END**

**          END**

{{notebox.jpg|NoteBox.jpg}}

**If you use the templates to generate your application, you will not need this technique. The templates automatically generate VIEWs when more than one table is referenced.**