翻译一下这条SQL语句.最好写出简单的.和这效果一样的句子.! ( 积分: 100 )

fncSql := 'select d.apply_id,ent_Name,Taskid from (SELECT apply_id,ent_Name FROM Exe_apply a,base_ent_info b where a.ent_id=b.ent_id and(apply_state_id=4 or apply_state_id=7)and gist_trade_id in (select Trade_id from exe_user_trade where user_id='+TShare_WorkTag.UserID+')) d left outer join Exec_task c on d.apply_id=c.Planid

这语句不复杂,我感觉都不需要翻译,只是我觉得原作者写的时候应该适当注意缩进,换行,看其来更结构话点,可读性高点.
SELECT apply_id,ent_Name FROM Exe_apply a,base_ent_info b where a.ent_id=b.ent_id and(apply_state_id=4 or apply_state_id=7)and gist_trade_id in (select Trade_id from exe_user_trade where user_id='+TShare_WorkTag.UserID+')) d
就是 把该查询结果作为 结果集 d.
整个就是:
select d.apply_id,ent_Name,Taskid from d left outer join Exec_task c on d.apply_id=c.Planid

接受答案了.