These are chat archives for eysteinn13/FraunhoferDBWebsite

8th
Jul 2015
Freyr12
@Freyr12
Jul 08 2015 15:23
SELECT l.price
FROM lineitem l, pos p
WHERE l.po_ID = p.po_ID
AND l.tool_ID = 'VAN5EM24'
AND p.receiving_date = (SELECT MAX(p1.receiving_date)
                        FROM pos p1)
GROUP BY l.tool_ID