Get max value when joining 3 tables in SQL
Assuming that  poitem.id is the same as po.id
SELECT
     pa.id,
     pi.id
FROM
    part pa INNER JOIN poitem pi ON pi.partid = pa.id
WHERE pi.id IN (SELECT po.id 
                FROM po 
                WHERE po.`date` = (SELECT MAX(`date`) FROM po))