You have no join condition in your SELECT. You should have a condition that tell which field in Conference link to Rooms, as in:

SELECT Conference.ConfNum;
   FROM Conference;
   INNER JOIN Rooms ON Conference.PK = Rooms.FK;
   WHERE Rooms.HallName=="Hewett" .OR. Rooms.HallName=="Manchester";
   INTO CURSOR tmp

HTH

>SELECT Conference.ConfNum, Conference.ConfName, Conference.CheckInBegin, ;
> Conference.CheckInEnd, Conference.CheckOutBegin, Conference.CheckOutEnd, ;
> Rooms.HallName FROM Conference INNER JOIN Rooms WHERE ;
> Rooms.HallName=="Hewett" .OR. Rooms.HallName=="Manchester" INTO CURSOR tmp
>
>Syntax error... =(