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... =(