. . . . . . . . . . . . . . . "/*[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\r\nFROM demo.acme.geographic_location \r\nJOIN demo.acme.location_address on geographic_location.location_address_identifier = location_address.location_address_identifier\r\nJOIN demo.acme.physical_location on geographic_location.physical_location_identifier = physical_location.physical_location_identifier\n/*]sqlquery]*/" .