帮忙看看这句话那里错了?急
select top 3 * from supplier1 where supplier_id in (select objectID from T_recommend where kind = '1' and toLanguage = '1' order by good desc ) and c_audit = '1' and province_id = '43' order by supplier_id desc
报措The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.