Results 1 to 2 of 2

Thread: searching

  1. #1
    baazil Guest

    Default searching

    i know that <BR> SELECT * FROM customers <BR>means selecting all info from the customers table in a db. Lets say i want to search 5 different tables (Named One, Two, Three, Four, Five) at once, is there a way to do this, is it as simple as <BR> SELECT * FROM one,two,thre,four,five<BR>?????<BR><BR>help would be greatly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: searching

    Yes. If you want all rows returned:<BR><BR>Select * from one, two, three, four, five <BR>(optional below here)<BR>where one.columnname = &#039whatever&#039 and three.columnname = &#039whatever&#039

Posting Permissions

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