SELECT
t.adjustment_reason,
t.iia_date,
t.iia_quantity,
im.description,
im.item_id,
im.upc_ean,
ip.ip_item_price
FROM
dbo.inventory_adjustments t,
dbo.item_master im,
dbo.item_price ip
WHERE
t.record_status <> 3
AND im.item_id = t.item_id
AND t.iia_date BETWEEN '02/01/2006' AND '02/14/2006'
ORDER BY
im.upc_ean
----------------------
Select t.IP_UNIT_PRICE
From dbo.ITEM_PRICE t
Where (t.ITEM_ID = 40036)
And ((t.IP_START_DATE <= '2/14/2006') AND ((t.IP_END_DATE >= '2/14/2006') OR (t.IP_END_DATE IS NULL)))
And (t.HOLD_PRICE = 0)
And t.RECORD_STATUS <> 3
the 40036 is the item_id
the date will have to be the iia_date in the first query because we need accurate prices for X date.