Re: SELECTing most recent date and JOINing tables

2003-10-14 Thread Roger Baklund
* Dusty Kleyboecker > I have two tables, a PROJECTS table and a COMMENTS table linked by > seq in a one to many relationship. In other words, there might be > several comment rows for the same project, with different dates. > > PROJECTS > > seq name startdate enddate > > 1 p1 02032002

SELECTing most recent date and JOINing tables

2003-10-14 Thread Dusty Kleyboecker
I have two tables, a PROJECTS table and a COMMENTS table linked by seq in a one to many relationship. In other words, there might be several comment rows for the same project, with different dates. PROJECTS seq name startdate enddate 1 p1 02032002 12202003 2 p2 04012003 10