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!no space between Comments and FROM

rudy
http://r937.com/|||...the sound you hear is me hitting my head on the table.

Thanks!@.!!!