vendor currency

SELECT
vndr.VNDR_NM,
ext.CURRENCY_FK,
ext.NATIONALITY_CD
FROM
pur_vndr_dtl_t vndr
left join
pur_vndr_dtl_ext_t ext ON
vndr.VNDR_HDR_GNRTD_ID = ext.VNDR_HDR_GNRTD_ID
WHERE
ext.CURRENCY_FK = 'SAR';