>
>cod,cliente,vencimento,valor
>
>001,001001,10/03/2003,34.67
>002,001001,10/02/2003,45.78
>003,001001,10/05/2003,56.78
>004,001002,10/03/2003,67.89
>005,001002,10/04/2003,65.43
>006,001003,10/06/2003,54.32
>
>deve ficar assim depois do select-sql.
>
>002,001001,10/02/2003,45.78
>004,001002,10/03/2003,67.89
>006,001003,10/06/2003,54.32
>
Walney;
Acho que isto ajudará:
SELECT *;
FROM table1;
WHERE Table1.vencimento < date();
ORDER BY Table1.cliente, Table1.vencimento
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
