流
流星雨夜
Unregistered / Unconfirmed
GUEST, unregistred user!
谁能帮我优化下面的语句,涉及的表很大,要很长时间才能出来<br>select serialid,shortname,filename,memo,<br>getdrawidchar(shortname) as drawidchar,getdrawidnum(shortname) as drawidnum from filelist where drawid='XX' and filename not in (select content from mis_code) <br>order by drawidchar,drawidnum<br><br>上面两个get是函数