Re: Find the record with the last operation

Article View: borland.public.interbase.sql

Article #903

Back to borland.public.interbase.sql Previous Next

#903

From: Safwan
Date: Sat, 14 Apr 2007 13:20

15 lines
1385 bytes


> TRUCK | DELIVERY | DATE | TIME
> --------------------------------------------
> 1    1    03/31/2007    10:15            *
> 2    1    03/31/2007    10:25
> 2    2    03/31/2007    11:25            *
> 3    1    03/31/2007    10:30
> 3    2    03/31/2007    11:30
> 3    3    03/31/2007    12:30            *

Select *
From DELIVERIES Inner Join TRUCKS On DELIVERIES.TRUCK = TRUCKS.TRUCK
Where DELIVERY = (Select Max(DELIVERY) From DELIVERIES Where TRUCK = 
TRUCKS.TRUCK AND DATE = '??/??/????')

Technical Details

Message-ID: <4620c6fa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <461fde4d$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,c901fd9553dd3596
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Safwan" <Safwan_maswadeh@yahoo.com>
Newsgroups: borland.public.interbase.sql
References: <461fde4d$1@newsgroups.borland.com>
Subject: Re: Find the record with the last operation
Date: Sat, 14 Apr 2007 15:20:04 +0200
Lines: 17
Organization: Safwan
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.6.67.115
Message-ID: <4620c6fa$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176553210 213.6.67.115 (14 Apr 2007 05:20:10 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message