When I attempt to execute this:

-------------------------------------------------------------
sql = "Select 
crew.SCENARIO,crew.CYCLE,crew.ECREW,crew.EDATE,crew.ABCR,stud.IndGrade,stud
.POSITION,stud.IndScore from tblCrewEvalData crew,tblStudentEvalData stud 
where crew.CEvalID = 33"

IF rs.State = 1 THEN
	rs.Close
END IF

rs.Open sql '<--------------------LINE 144
-------------------------------------------------------------

I get this:

---------------------------------
error '80004005' 
Unspecified error 

/xxxx/xxxxxx.asp, line 144
-----------------------------------



My goal is this:

I have two tables. I need to select every record of one student from the 
student table.  Each record has a number (ICEvalID) that corresponds with 
a scenario in the crew table (CEvalID).  I need to output the data for the 
scenario and then the data for the student during that scenario.  Please 
someone help.

Thank you

Al

Follow up:

Using * in the select statement instead of field names works. Using field 
names w/o table names does not work.