select * from (用select 查询到的结果)t

select * from (select a.inv_no , b.inv_nam ,a.re_quan-a.is_quan+a.ad_quan as r_quan,b.unit,a.st_no,d.st_nam from st_end a, inv b, storage d where a.re_quan-a.is_quan+a.ad_quan>0 and a.inv_no=b.inv_no and a.st_no=d.st_no AND( a.st_no='CY' OR A.ST_NO='CD' OR A.ST_NO='AD') AND INV2_NO='A') t where ......a.re_quan-a.is_quan+a.ad_quan as r_quan计燃备搏算滚丛列加皮祥个别名啊

标签：select,查询,结果