Help with SQL

[PakRicard]

Hi all:

I'm trying to get in a single SQL:
stockid
description,
(materialcost + labourcost + overheadcost) as standard cost
from stockmaster
and
last price paid,
supplierid,
currency of the supplier,
effectivefrom date
from purchdata (but only the very last information from purchdata)

for all stockid with purchdata

I'm getting a too complicated SQL that gets out of memory problems.

is there a simpler way to do it?

Thanks!!!