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
WHERE LANCPROP.COD_PROP=CADPROP.COD_PROP
AND PARAMETROS.COD_TXADM=LANCPROP.COD_LANC
AND ( LANCPROP.DT_LANC> '01/01/2010' And LANCPROP.DT_LANC< '01/25/2010')
ORDER BY 2