PMFJI, one minor irrelevant thing: using '==', instead of '=' may effectively kill Rushmore.

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