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... =(
Thanks for your help.
>Hi Jason,
>
>>How would I go about selecting multiple fields from different tables where the conditional expression tests fields from different tables?
>
>SELECT TableA.Field1, TableA.Field2, TableB.Field1, TableB.Field2 ;
>FROM TableA INNER JOIN TableB ;
>ON TableA.KeyField = TableB.ForeignKeyField
>
>HTH,