/*[sqlquery[*/ SELECT CAST(geographic_location_identifier as VARCHAR) as geographic_location_identifier, CAST(line_1_address as VARCHAR) as line_1_address, CAST(line_2_address as VARCHAR) as line_2_address, CAST(municipality_name as VARCHAR) as municipality_name, CAST(location_address.state_code as VARCHAR) as state_code, CAST(postal_code as VARCHAR) as postal_code, CAST(country_code as VARCHAR) as country_code, CAST(latitude_value as VARCHAR) as latitude_value, CAST(longitude_value as VARCHAR) as longitude_value
FROM demo.acme.geographic_location
JOIN demo.acme.location_address on geographic_location.location_address_identifier = location_address.location_address_identifier
JOIN demo.acme.physical_location on geographic_location.physical_location_identifier = physical_location.physical_location_identifier
/*]sqlquery]*/