Assuming invitm is required, the following result was found.
in addition to including the customer ID and invoice ID, I'm calling this one "Invoice Items vs SoPo Items": SELECT MAX(invitm."Invoice ID") AS "Invoice ID", MAX(inv."Invoice Date") AS "Invoice Date", MAX(abs_month(inv."Invoice Date")) AS "Invoice Month...