SELECT NOTAFISC.NUM_NF,NOTAFISC.DT_EMIS,NOTAFISC.DT_QUITACAO,NOTAFISC.STATUS,NOTAFISC.VLR_NF,NOTAFISC.VLR_TX_ADM,CADIMOV.COD_IMOV,CADIMOV.ENDERECO,CADINQU.NOME
FROM NOTAFISC,CADIMOV,CADINQU,CTRLOCA
WHERE CTRLOCA.COD_IMOV=CADIMOV.COD_IMOV
AND CTRLOCA.COD_INQU=CADINQU.COD_INQU
AND NOTAFISC.COD_LOC=CTRLOCA.COD_LOC
AND ( NOTAFISC.DT_QUITACAO>= '05/01/2006' And NOTAFISC.DT_QUITACAO<= '05/31/2006')
AND ( NOTAFISC.STATUS= 'Q')