Extração de dados

Select

PRI.PRCNAM as NOMPRO,

PRI.PRCIID as CODINS,

PRI.PROCID as CODPRO,

PRI.PRCVER as VERPRO,

PRI.INIDAT as DATINI,

PRI.INITIM as HORINI,

PRI.ENDDAT as DATFIM,

PRI.ENDTIM as HORFIM,

USU.NOMUSU as USUINI,

PRI.USUINI as CODINI,

PCY.PRCSTP as PASPRO,

PCY.ACTVID as TARIDD,

PCY.ACTNAM as TARNOM,

PCY.INIDAT as DATINA,

PCY.INITIM as HORINA,

PCY.ENDDAT as DATFIA,

PCY.ENDTIM as HORFIM,

PCY.USURES as RESCOD,

RES.NOMUSU as RESNOM,

PCY.USUEXE as RESEXE,

EXE.NOMUSU as NOMEXE,

PCY.EXPDAT as DATEXP,

PCY.EXPTIM as HOREXP,

PCY.PCYTYP as TARTYP

from

W200PCY PCY,

W200PRI PRI,

R999USU USU,

R999USU RES,

R999USU EXE

where PCY.PRCIID = PRI.PRCIID

AND PRI.USUINI = USU.CODUSU

AND PCY.USURES = RES.CODUSU

AND PCY.USUEXE = EXE.CODUSU

AND PRI.INIDAT >= 'data de inicio' //Data de início para consulta

AND PRI.ENDDAT <= 'data de fim' //Data de fim para consulta