/*[sqlquery[*/ SELECT CAST(ca.claim_identifier as VARCHAR) as claim_identifier, CAST(ca.claim_amount_identifier as VARCHAR) as claim_amount_identifier, CAST(ca.claim_amount as INTEGER) as claim_amount
FROM demo.acme.claim_amount ca
JOIN demo.acme.loss_payment lp on ca.claim_amount_identifier = lp.claim_amount_identifier
/*]sqlquery]*/