Subject sql puzzle
Author James
Happy new year everyone. :-)

Can somebody help me with this. I want to form a sql statement that
could get the price of each item from the lastest invoice. Here are
some of the table definition. the ITEM table has (itemid, itemname),
INVOICE table has (invno, invdate), INVOICEDETAILS table(invno, itemid,
price). This definition table is not the complete one I just list the
important one. Iam having a problem contructing it, Iam trying to avoid
using Stored Procedures or Views as much as possible.