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