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?