Skip to Content
0
Former Member
Jun 20, 2006 at 10:36 AM

how to format a query

19 Views

Hello,

When I make a query like this:

SELECT t1.price as 'listprice' FROM itm1 t1 WHERE t1.pricelist = 2

I get my prices with 5 decimals

If I use this:

SELECT T0.ItemCode,

(SELECT t1.price FROM itm1 t1 WHERE t1.itemcode = t0.itemcode AND t1.pricelist = 2) as 'listprice'

FROM OITM T0

I only get 2 decimals, but I need 5

What should I do?