I am having some trouble getting the following limit to work...


UPDATE works SET w_exhibition = (select e_name FROM exhibitions WHERE e_num_works = (select MIN(e_num_works) FROM exhibitions)) where w_location = 'storage' LIMIT (select MIN(e_num_works) FROM exhibitions);

Everything works fine except for the LIMIT. If I change it to just say Limit 6 I still get an error. Am I doing something wrong?

Thanks
Zak