Results 1 to 3 of 3

Thread: Join Issue

  1. #1
    Join Date
    Apr 2003
    Posts
    114

    Unanswered: Join Issue

    I am getting this error message:

    The column prefix 'TrainingData' does not match with a table name or alias name used in the query.

    From this code (asp/ado/sql server):

    sql = "SELECT FirstName, LastName, Grade, DayDate, Effort, UnitMeas,
    Partners, Comments"
    sql = sql & "FROM PartData, TrainingData WHERE TrainingData.PartID =
    PartData.PartID AND TeamID = " & Session("teamid") & ""

    Set rs=conn.Execute(sql)

    Anyone see anything wrong with it? The tables are named correctly.

    Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no space between Comments and FROM


    rudy
    http://r937.com/

  3. #3
    Join Date
    Apr 2003
    Posts
    114

    Duhhhh...

    ...the sound you hear is me hitting my head on the table.

    Thanks!@!!!

Posting Permissions

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