Hi all, Thanks for your suggestions. On the advise of Jon Gramm I deleted all .tmp files I could, to see if that was why the program was crashing. It wasn't. I've tried numerous things; indexing the field I'm joining on, making sure that the table fields are the same, and saving the matched query as a base table, and many different syntaxes but none of these things have made a difference.
Thing is I don't even get an error message saying why the query doesn't work because the program just freezes. I ended up saving the files as .dbf and running a Find Unmatched Records query in Access which worked fine. I then imported the table back into MapInfo. I would obviously like to avoid this in the future and finding unmatched records is something that will come up quite frequently in the work I'm doing, so any other suggestions would be much appreciated! Thanks, Christine