Page MenuHomePhabricator
Paste P16837

state
ActivePublic

Authored by jgleeson on Tue, Jul 20, 4:44 PM.
SELECT
state.name AS state, a.*
FROM
civicrm.civicrm_address a
INNER JOIN
civicrm.civicrm_state_province state ON state.id = a.state_province_id
WHERE
contact_id = 306742