Customer Account Profiles SQL Query

select
p.party_name,
ca.account_number,
ca.account_name,
cp.status,
cp.credit_checking,
cp.credit_hold,
cp.tolerance

from
hz_parties p,
hz_cust_accounts ca,
hz_customer_profiles cp

where
p.party_id=ca.party_id and
cp.cust_account_id=ca.cust_account_id