select  project_name,pk_station,station_id,storet_identifier,   
        station_name,        
        water_resource,
        waterbody_name,
        well_type,
        analysis_method,
        pk_param_code,
        parameter,
        value,
        value_qualifier,
       
        mdl,
        PQL,
        units,
       
        ANALYSIS_METHOD,
        QC_BATCH,
        waterbody_type,
        station_alias,
        surface_water_class,
        result_comment, 
        t_sample.comments t_sample_comments, 
        t_station.comments  T_Station_Comments, 
        to_char(collection_date,'DD-MON-YY') collection_date, 
        to_char(collection_date,'HH:MI:SS AM') collection_time,
        release_date,
        sample_type,
        tmdl_basin,
        hydrologic_unit_name,
        dep_district,
        county_name,
        planning_unit,
        water_mangement_district,
        t_sample.reporting_unit_name,
        wbid,
        
        latitude,
        longitude,
        dcd_datum_id,
        cmcd_coordinate_method_id,
        lat_dd,
        lat_mm,
        lat_ss,
        long_dd,
        long_mm,
        long_ss,  
        t_station.gis_albx,
        t_station.gis_alby, 
        LOCATIONAL_QA_STATUS,
        sample_depth,
        well_drill_date,
        well_casing_depth,
        well_total_depth,
        well_casing_material,
        dep_well_identifier,
        florida_unique_well_identifier,
        well_status,
        well_construction_method,
        well_lift_type,
        well_finish,
        well_screen_begin_depth,
        well_screen_end_depth,
        well_screen_material,
        well_casing_diameter, 
        land_surface_elevation,
        well_measuring_pt_elevation,
        well_water_level_recorder, 
        WELL_LEAD_WEIGHT,
        WELL_HYDROLOGIC_DATA ,
        SUBAQUIFER,
        sampled_background_well,
        sampled_visa_well,
        sampled_hrspws_well,
        sampled_tv_stations,
        sampled_status_network_station,
        sampled_wqas_station,
        fk_super_project, 
        fk_project_type, 
        collection_agency,        
        primary_sampling_agency,
        agency_maintaining_station_inf,  
        pk_sample, 
        pk_result, 
        fk_customer, 
        data_source,
        project_name,
        pk_project,
        date_storet_upload,
        upload_date,
        storet_name,
        lab_name,
        analyzing_agency 

from gwis.t_project, gwis.t_station, gwis.t_sample, 
gwis.t_result,  gwis.t_parameter
where pk_station=fk_station and pk_project=fk_project and pk_sample=fk_sample 
and pk_param_code=fk_param_code  
and waterbody_type = 'aquifer'
--and t_project.PK_PROJECT = 'SPRG0704'
order by t_sample.pk_sample