Results 1 to 2 of 2

Thread: Search ALL

  1. #1
    Join Date
    Jul 2004
    Posts
    56

    Unanswered: Search ALL

    This is a long shot really, but is on my wish list.

    I have a database that contains around 7 tables all containing fields that include Date/Time, Text and Memo. Is there a way of a user entering a search ie *667556* that will then search every table for the occurrence of 667556. Any ideas?

    Thanks

    Col_Bol

  2. #2
    Join Date
    Jun 2004
    Posts
    92
    Use a union query. Example below. Takes fields companyname and city from both tables of suppliers and customers and combines them.

    Code:
    SELECT [CompanyName], [City]
    FROM [Suppliers]
    
    UNION SELECT [CompanyName], [City]
    FROM [Customers];
    Last edited by sionus; 08-24-04 at 13:18.

Posting Permissions

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