Microsoft KB Archive/45930

{| = Purpose of the SQL Button in the Q+E File Open Dialog =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q45930

SUMMARY
Clicking the SQL... button from the File Open dialog causes the SQL Query dialog to appear. At this point, a SQL query can be used to display the results, rather than having to open all of the files involved.

For example, if the department names in each city and state are needed, entering the following SQL query displays the results:

SELECT LOC_CITY, LOC_STATE, DEPT_NAME FROM LOC.DBF, DEPT.DBF WHERE LOC.LOC_ID=DEPT.LOC_ID
 * }