Query

------=_NextPart_000_000D_01CC43A9.AA5987F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I have 2 tables:
Sales> Code, Price, sDate
History>Code, Cost, hDate

The sales record sales for each product by its code. The History table =
has the cost history of each product at different date.

I need to know the last cost of each product in the sales table at the =
date of the sales.

Can anyone help me with the query?

It should be something like : select a.code,a.price,b.cost,a.sDate from =
sales a, history b where a.code=3Db.code and b.hdate
Thanks.

Vel

------=_NextPart_000_000D_01CC43A9.AA5987F0--