SELECT LANCPROP.COD_PROP,CADPROP.NOME,CADPROP.CNPJ_CPF,CADPROP.ENDERECO_RES,CADPROP.BAIRRO_RES,CADPROP.CIDADE_RES,CADPROP.UF_RES,LANCPROP.DT_LANC,LANCPROP.VLR_LANC
FROM LANCPROP,CADPROP,PARAMETROS,RIMOPROP
WHERE PARAMETROS.COD_TXADM=LANCPROP.COD_LANC
AND RIMOPROP.COD_PROP=CADPROP.COD_PROP
AND LANCPROP.COD_IMOV=RIMOPROP.COD_IMOV
AND ( LANCPROP.DT_LANC>= '05/01/2010' And LANCPROP.DT_LANC< '06/01/2010')
ORDER BY 1