Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 3.01 » View Incident Report |
Serious |
Reported By: Marco Antonio Reported On: 9/20/2001 For: Version 3.01 Build 1 |
select FDSC.NrFunc, FDSC.Sigla, FDSC.Periodo, FLTP1.prd_dia, FLTP1. prd_hrs, count(FDSC.Sigla) as faltas from faltsdsc FDSC left join flttmps FLTP1 on FDSC.Periodo = FLTP1.cod left join pessoal PSS1 on PSS1.NrFunc = FDSC.NrFunc left outer join Regimes RGM1 on RGM1.Cod = PSS1.Regime where (FDSC.sigla in ('t1', 'FE', 'IJ')) and (Data between '1999-9-1' and '2000-8-31') and (FDSC.periodo > 0) and RGM1.regimeFaltas = 1 union ALL select FABN.NrFunc, FABN.Sigla, FABN.Periodo, FLTP1.prd_dia, FLTP1. prd_hrs, count(FABN.Sigla) as faltas from faltsabn FABN left join flttmps FLTP1 on FABN.Periodo = FLTP1.cod left join pessoal PSS1 on PSS1.NrFunc = FABN.NrFunc left outer join Regimes RGM1 on RGM1.Cod = PSS1.Regime where (FABN.sigla in ('t1', 'FE', 'IJ')) and (Data between '1999-9-1' and '2000-8-31') and (FABN.periodo > 0) and RGM1.regimeFaltas = 1 Group by FDSC.NrFunc, FDSC.Sigla, FDSC.Periodo
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |