Re: Join only the latest entry...

2003-12-03 Thread Roger Baklund
* Ville Mattila > I have a table including information about my projects, the structure > has each id and name. Then I have another table including status > information of each project: entryid, projectid, status and timestamp. > > Is there any possibility to fetch a list of projects with the most

Re: Join only the latest entry...

2003-12-03 Thread Skippy
On Wed, 03 Dec 2003 11:07:28 +0200 Ville Mattila <[EMAIL PROTECTED]> wrote: > I have a table including information about my projects, the structure > has each id and name. Then I have another table including status > information of each project: entryid, projectid, status and timestamp. > > Is t

Re: Join only the latest entry...

2003-12-03 Thread Stephen Fromm
- Original Message - From: "Ville Mattila" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 4:07 AM Subject: Join only the latest entry... > Hello there, > > I have a table including information about my projects, the structu

Join only the latest entry...

2003-12-03 Thread Ville Mattila
Hello there, I have a table including information about my projects, the structure has each id and name. Then I have another table including status information of each project: entryid, projectid, status and timestamp. Is there any possibility to fetch a list of projects with the most recent s