Results 1 to 2 of 2

Thread: searching

  1. #1
    baazil Guest

    Default searching

    I would like to search more then one table in a database. To search one table i would set my SQL statement to say something like this<BR> SQL = SELECT * FROM Items<BR>Lets say i have tables Items, Calculations, Prices, and Reservations... how would my SQL Statement look then?<BR>possibly this?<BR> SQL = SELECT * FROM Items, Calculations, Prices, Reservations<BR><BR>Lets also say that Items and Calculations has the same column name lets say DATE, would this be a problem??<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: searching

    The proper way to select information from different table us to use the table.column method. This way, the SQL is stating which table to use. For example, from your information you had, and assuming you have a field that links that databases together name ID:<BR><BR>Select Calculations.Price, Calculations.Price, Calculations.Date, Prices.Item, Prices.ID from Calculations, Prices where Calculations.ID=Prices.ID<BR><BR>Good Luck.<BR><BR>Brandon

Posting Permissions

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