IN Clause (SQL Only)
See Also Example
Use the IN clause to retrieve data stored in more than one database, such as a dBASE or Paradox database or in another Visual Basic database. For example, you can use the IN clause to select all customers in a dBASE or Paradox table whose Customer ID has "A" as the first letter.
You can use IN to connect to only one external database at a time. An external database is one other than the current database.
The IN clause has two parts: The databasename and connect string. The databasename is a fully-qualified path to the file or directory containing the database table and connect contains the database type and other parameters as needed.
To specify an external database, append a semicolon (;) to the connect part, and enclose it with single or double quotation marks. For example, 'dBASE IV;' or "dBASE IV;".
The following example uses the IN clause to specify a dBASE IV database table "SALES":
IN "C:\DBASE\DATA\SALES" "dBASE IV;"
WHERE CUSTOMERS.CustomerID Like "A*"