Or put the sub-query

> (select b.PP_PRICECODE from partprice b
> where (b.pp_part = a.part)) as pp_code

directly into SP.

> select SOURCE, PART, WAREHOUSE, CONDITION, NOTESFLAG,
> DESCR, QTY, ONORDER, AVG_COST, PRICE, ORGIN,
> WHOLEPRICE, RETAILPRICE, WEIGHT, LOC1, LOC2, SLOW, pp_code
> from spviewparts('902090', 'T', 'F', 'F') a
> order by SortOrder, qty desc, part, warehouse, condition

Ivan
http://www.volny.cz/iprenosil/interbase