SQL Query

Results 1 to 2 of 2

Thread: SQL Query

  1. #1
    any-who Guest

    Default SQL Query

    Is there any way to search all the tables in a database against a search query from a form without having to list each table & column separately? <BR><BR>Thanks.

  2. #2
    Pachebel Guest

    Default Select *

    Well,<BR><BR>I know of nothing of tables, but you can say:<BR><BR>select * from table1,table2,table3<BR>that saves column name typing. however in the production world, select * is something, i don&#039t recommend, but then again, i think a drink a day will keep the doctor away.

Posting Permissions

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