Re: MAX record on GROUPS

2001-01-19 Thread Bob Hall
This gives me one instance of each file name in the DOCUMENTS column submitted into the database. The only thing though is it gives me the oldest of the file name in the DOCUMENTS column which are submitted. Any ideas how to get the newest one? I've tried adding: , MAX(ID) after the SELECT *.

MAX record on GROUPS

2001-01-18 Thread Muscarello, Roger
This gives me one instance of each file name in the DOCUMENTS column submitted into the database. The only thing though is it gives me the oldest of the file name in the DOCUMENTS column which are submitted. Any ideas how to get the newest one? I've tried adding: , MAX(ID) after the SELECT *.