|
Is this supposed to be a single row only? Or could you have several rows for the earlies date? For now, I'll assume the second. With Hx (Div, Acct, PO#, HxBegin) as ( Select Division, Account, PO#, Min(ChgDtCen*1000000 + ChgDt6) From MyFile Group By Division, Account, PO# ) Select a.* from MyFile a inner join Hx on(a.Division=Hx.Div and a.Account=Hx.Acct and a.PO#=Hx.PO# and ChgDtCen*1000000+ChgDt6=Hx.HxBegin) hth, Eric -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jeff Young Sent: Friday, December 01, 2006 1:13 PM To: midrange-l@xxxxxxxxxxxx Subject: SQL Question I have a history file with the following fields : Division Account PO# Date Changed YYMMDD Date Changed Century 1/0 Cancel Date Old / New Code O/N . . . . Is there a way using SQL to select the data from the record with the oldest date for a given Division, Account & PO#. TIA, Jeff Young Sr. Programmer Analyst Dynax Solutions, Inc. A wholly owned subsidiary of enherent Corp. IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3 IBM Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3 ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.