1 Reply Latest reply on May 11, 2006 4:24 AM by Mal9

    Help adding Query to code...

    Mal9
      Can anyone tell how I get the following code to select the UserName's "Location" and "Country" rather than just the 1st country and location in the database?

      SELECT tblSuppliers.idSupplier, tblLocation.Location, tblCountry.Country
      FROM tblCountry INNER JOIN (tblLocation INNER JOIN tblSuppliers ON tblLocation.idLocation = tblSuppliers.iLocation) ON tblCountry.idCountry = tblSuppliers.iCountry
      WHERE UserName = 'MMColParam'

      tblSuppliers
      idSupplier
      Username
      bla
      bla
      bla
      iLocation
      iCountry

      iLocation and iCountry have a relationship with idCountry & idLocation below.

      tblCountry
      idCountry
      Country

      tblLocation
      idLocation
      Location