Inner Joins & Request Querystring

Results 1 to 2 of 2

Thread: Inner Joins & Request Querystring

  1. #1
    Join Date
    Dec 1969

    Default Inner Joins & Request Querystring

    I am having a horrible time trying to get my inner join and links to work. Here is the scenario. A browser clicks off of one page and the employer id is passed to the more descriptive page that contains everything about that employer. I want to then inner join another table tMajor that has info on what they majored in in college. Any ideas?<BR>Here is what I have so far. Any help would be appreciated.<BR>Thanks.<BR> <BR>- Jason<BR> <BR>sql = "SELECT tCompanyProfile.CompanyName,tMajor.Econ FROM tCompanyProfile INNER JOIN tMajor ON tCompanyProfile.MajorID = tMajor.MajorID WHERE tCompanyProfile.EmployerID = " & Request.Querystring ("EmployerID")

  2. #2
    Franco Guest

    Default RE: Inner Joins & Request Querystring

    Jason<BR><BR>Have you tried swapping the INNER JOIN statement with:<BR><BR>WHERE tCompanyProfile.MajorID = tMajor.MajorID AND tCompanyProfile.EmployerID = " & Request.Querystring ("EmployerID")<BR><BR>hth<BR><BR>Franco

Posting Permissions

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