sql server ce query question

[jason213123]

hi,
i have two tables
products that have the name and code and stock_products that have the
current stock

and i want in a single query see the especific value of the table stock_products
for example

from table one: code of product and from table two the stock of the
product

in secund table i have many records that belong for the same product
but i want only the last record

now the great question
how can i do that?
thanks a lot for your help

i using sql server ce

[Hack]

How are the two linked?

From your description, I see no common fields which would indicate how a record in one table is directly related to a record in the other table.

[jason213123]

hi,
the colums of the stock_products are:

stock
codartigo
date

and the colums of the products are:

id
codartigo
date

the colums in common if: codartigo
thanks a lot for your help