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

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

Try this:

select t.*

from (select a.inv_no , b.inv_nam ,

a.re_quan-a.is_quan+a.ad_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

A...

a.is_quan+a.ad_quan 改为 a.is_quan+a.ad_quan as quan

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 ...

标签：select,查询,结果