Results 1 to 2 of 2

Thread: Database

  1. #1
    Sharon Guest

    Default Database

    I am trying to pull a location and name out of a database<BR>The location is a number in a field in a different table and the name is a name in a field in a different table also, all I want to display is the name, not the location number. How would I write the Select statement to pull the name not the number.<BR><BR>Thanks<BR>Sharon

  2. #2
    Join Date
    Dec 1969

    Default RE: Database

    Assuming that you have both name and location in one of the tables (and I don&#039t see how you could associate them otherwise), why couldn&#039t you just use<BR><BR>"Select name from tablename where location = " & location_name<BR><BR>Maybe you need to provide more info?

Posting Permissions

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