hv_labgen_physicians_npi_v dll

CREATE  VIEW "HV_LABGEN_PHYSICIANS_NPI_V" AS
  select    a.source_clinic,
    a.recnum,
    a.name,
    a.title,
    a.npi,
    b."GROUP"       AS npi_sales_group,
    b.from_date,
    b.to_date,
        b.longitude,
        b.latitude
from    hv_labgen_clients   a
left join    hv_d_npi_list       b
on   b.referring_provider_npi     =   a.npi;