select P.PO_ID, P.PO_ISSUER, P.PO_ISSUEDT, P.PO_SHIPBY from RETAILBUYER_POHEADER P inner join RETAILBUYER_VENDOR V
on P.VENDOR_ID = V.VENDOR_ID
where YEAR(P.PO_ISSUEDT) = 2021 AND YEAR(P.PO_SHIPBY) = 2021