<hktables> SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; </hktables>

<hktables> SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='Assan' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; </hktables>

<hktables> SELECT i.id,i.name, h.stock, h.weight, h.cost, h.date from items i,itemshistory h WHERE i.vendor='OrangeRx' AND h.id=i.id AND h.date=(SELECT MAX(hs.date) FROM itemshistory AS hs WHERE hs.id=i.id) group by h.id ORDER BY i.name, h.date desc; </hktables>