/*[sqlquery[*/ SELECT CAST(policy.policy_identifier as VARCHAR) as policy_identifier, CAST(party_identifier AS VARCHAR) as party_identifier
FROM demo.acme.agreement_party_role
JOIN demo.acme.policy on agreement_party_role.agreement_identifier = policy.policy_identifier
WHERE agreement_party_role.party_role_code = 'PH'
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy.policy_identifier as VARCHAR) as policy_identifier, CAST(party_identifier AS VARCHAR) as party_identifier
FROM demo.acme.agreement_party_role
JOIN demo.acme.policy on agreement_party_role.agreement_identifier = policy.policy_identifier
WHERE agreement_party_role.party_role_code = 'PH'
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy.policy_identifier as VARCHAR) as policy_identifier, CAST(party_identifier AS VARCHAR) as party_identifier
FROM demo.acme.agreement_party_role
JOIN demo.acme.policy on agreement_party_role.agreement_identifier = policy.policy_identifier
WHERE agreement_party_role.party_role_code = 'PH'
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy.policy_identifier as VARCHAR) as policy_identifier, CAST(party_identifier AS VARCHAR) as party_identifier
FROM demo.acme.agreement_party_role
JOIN demo.acme.policy on agreement_party_role.agreement_identifier = policy.policy_identifier
WHERE agreement_party_role.party_role_code = 'PH'
/*]sqlquery]*/