freinds i am tring to execute following query

can any one tell me how can i correct it?
as it is not executing .

i explain it--

actually i am trying to retrieve information of persons which meet a parameter
given by the user .
the information is distributed among differenr tables.

one thing more the qualification table has multiple records for a person.

so please help me solve this problem.


one thing more i have made use of session variables quite extensively.
is that harmful??

SQL = "SELECT DISTINCT A.EMAILID,A.FIRST_NAME,A.MIDDLE_NAME,A.LAST_NAME,B.QUALIFICATION
"
SQL = SQL & " FROM PERSONAL_INFO A,QUALIFICATION_TABLE B"
SQL = SQL & " WHERE A.EMAILID = B.EMAILID " 'AND B.EMAILID IN "
SQL = SQL & " ( SELECT EMAILID FROM CANDIDATE_CURRENT_EMPLOYMENT "
SQL = SQL & " WHERE CURRENT_LEVEL = " & chr(39) & session("rel") & chr(39)
& ")"