>I need a SQL statement that will select a list of UNIQUE endors from a table and order them by last pay date. I am pulling the VENDID, VENDNAME, INVNUM, CHKNUM,CHKDATE,DTOS(CHKDATE), and CHKAMOUNT from a single table (CD). A simple select distrinct will not work because each vendor has multple records for different INVNUM's. Help Please
Select * From vendors Into cursor tmp order by vendid,chkdate
Select * From tmp Group by vendid
BTW, your table structure implies that you better divide your table into two:
1. Vendors: vendid,name
2. Invoices: vendid,invnum,date
Edward Pikman
Independent Consultant