searching tables

Results 1 to 2 of 2

Thread: searching tables

  1. #1
    Join Date
    Dec 1969

    Default searching tables

    Is it possible to build a search engine that can search through several tables in a database.Or would u advise me to build a search engine were the user chooses which table he wants to choose from. Which is more practical?<BR><BR>Thanks for your help

  2. #2
    Join Date
    Dec 1969

    Default RE: searching tables

    To search multiple tables you need to execute the SQL on each of the tables, so unless the tables are the same then you would need a different SQL statement for every one, if they are the same then you can simply do a single SQL statement with a UNION statement to join them.<BR><BR>You could list the tables by using sp_tables (SQL Server) or ADOX (Access), you could then loop through the table list and perform a query on each.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts