How to get party tax profile third party and third party site?

We would to get a query to extract party tax profile third party and third party site but but with the one we used we can only extract third parties:

Select
zxp.PARTY_TYPE_CODE,
zxp.TAX_CLASSIFICATION_CODE,
hzp.PARTY_NUMBER,
hzp.PARTY_NAME,
zxp.SITE_FLAG
from HZ_PARTIES hzp,
ZX_PARTY_TAX_PROFILE zxp,
where 1=1
AND zxp.PARTY_ID = hzp.PARTY_ID

What is a condition to extract both?

Thanks,

Regards