'all table' queries

Results 1 to 2 of 2

Thread: 'all table' queries

  1. #1
    Join Date
    Dec 1969

    Default 'all table' queries

    Hi,<BR><BR>Is it possible to write a &#039;general&#039; query for a relational database where every value in every column of every table in the database is tried as a match against a query string? I know it&#039;s possible if you sprcify every table and every column in your SELECT statement, joined together with OR but I wondered if there was a more &#039;shorthand&#039; way of doing it?

  2. #2
    Join Date
    Dec 1969

    Default RE: 'all table' queries

    As a thought....<BR>you can determine a loop checking each column within a loop of each table this will give the advantage of haneing the variables Tablename and columnname for you

Posting Permissions

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