View: core.tax_authority_scrud_view

 CREATE OR REPLACE VIEW core.tax_authority_scrud_view
 AS
 SELECT tax_authorities.tax_authority_id,
    ((tax_master.tax_master_code::text || '('::text) || tax_master.tax_master_name::text) || ')'::text AS tax_master,
    tax_authorities.tax_authority_code,
    tax_authorities.tax_authority_name,
    ((countries.country_code::text || '('::text) || countries.country_name::text) || ')'::text AS country,
    ((states.state_code::text || '('::text) || states.state_name::text) || ')'::text AS county,
    tax_authorities.zip_code,
    tax_authorities.address_line_1,
    tax_authorities.address_line_2,
    tax_authorities.street,
    tax_authorities.city,
    tax_authorities.phone,
    tax_authorities.fax,
    tax_authorities.cell,
    tax_authorities.email,
    tax_authorities.url
   FROM core.tax_authorities
   JOIN core.tax_master ON tax_authorities.tax_master_id = tax_master.tax_master_id
   JOIN core.countries ON tax_authorities.country_id = countries.country_id
   LEFT JOIN core.states ON tax_authorities.state_id = states.state_id;