select  fk_project,pk_sample,fk_data_source_code,project_name,storet_identifier,fk_data_source_code,fk_project,fk_station, station_id,fk_collection_date,collection_time,sample_comments_sample_depth,waterbody_type   
       
        fk_super_project, 
        fk_project_type, 
        waterbody_type,        
        primary_sampling_agency,
        agency_maintaining_station_inf,  
        
        fk_customer, 
        data_source,
         collection_agency,
        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 waterbody_type = aquifer;