Christoph
|
| Posted: 07/17/2003, 9:13 PM |
|
I have an Access-Database with 16 different tables and would like to implement a global search engine into my Intranet (ASP). This search engine should search for keywords in ALL tables. Does anyone know how to do that ????
Thanks in advance.
Christoph
|
|
|
 |
rrodgers
|
| Posted: 07/21/2003, 12:05 PM |
|
Does Access support the Union operator? If it does then perhaps you can construct your own SQL to return the results from all the tables?
rob
>>
UNION Operator
Combines the results of two or more queries into a single result set consisting of all the rows belonging to all queries in the union. This is different from using joins that combine columns from two tables.
Two basic rules for combining the result sets of two queries with UNION are:
The number and the order of the columns must be identical in all queries.
The data types must be compatible.
|
|
|
|
|
