子查询用的sql

select obj.uri,obj.mc,ter.address,gy.bzcontent,cv.value from eb_gridobj obj,
es_codevalue cv,
eb_gyyh gy,
ep_terminalobj tob,
ep_terminal ter
where obj.uri = gy.uri
and gy.uri = tob.objuri
and tob.termuri = ter.uri
and ter.channeluri = cv.uri

http://extjs.com/forum/showthread.php?t=72803