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

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 structure has each id and name. Then I have

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 there

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