I have the below query and I embeded a query within a query and I am just wondering if I could you the field from the embeded query to display the out put?
select c.iplineno, c.bidprice, b.vendor, v.vnamel,l.lcontid, t.datelet, func_get_county_name (ccnty1) county, e.iplineno, t.iunits,t.idescrl
from bidtabs c, bidders b, vendor v, letprop l, bidlet t, proposal p, propproj x, project pr,estcatg g, estitem e,
(select e.eiitem, e.iplineno,substr(e.eiitem ,1,4)||'.'||substr(e.eiitem ,5,9) , i.idescrl, SUM (e.iqty) Quantity , i.iunits
from estitem e , itemlist i
where i.item = e.eiitem
and l.lcontid='070038'
group by e.eiitem, e.iplineno,i.idescrl, i.iunits) t
where c.call = b.call
and c.letting = b.letting
and c.vendor = b.vendor
and b.vendor = v.vendor
and b.call = l.call
and b.letting = l.letting
and l.letting = t.letting
and l.lcontid = p.contid
and p.contid = x.contid
and x.pcn= pr.pcn
and pr.pcn=g.pcn
and e.cn = g.cn
and e.pcn = g.pcn