Are you running this through somehting other than Microsoft SQL server? "{of" is not somehting SQL would understand to my knowledge. Also you have spaces in your table names which would have to be in cased in [].
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.