First, thank you very much for trying but you were a bit off the mark but
close. Second, posting_date being of type char(4) is quite legal and
irrelevant for this exercise but for argument sake lets say char(15) but
apart from all that...
Your sql statement was close but it only update 4 out of
Ok here is what looks like a good one that has stumped me.
Let me set it up... I have two tables in my database test. They are
called journal and distrib.
journal looks like this (condensed)
Table "journal"
Attribute | Type | Modifier
+-+---
Oranges June 7, 2000
I know this doesn't work but I need something like it.
or something like
select * from basket where max(date) and fruit='Apples';
This would yield me:
15
Apples July 20, 1999
Thank you in advan
ld yield me:
15
Apples July 20, 1999
Thank you in advance,
--
Steve Meynell
Candata Systems
Joel,
Thank you very much. I gave that a try and it worked perfectly. It
definately was the distinct keyword I was missing.
Thanks Again,
Steve
Joel Burton wrote:
>
> Will DateStamp being the date of insertion? If so, is it that you want
> the record for the most recent (largest) datesta
ost recent of these Batch Numbers.
--
Steve Meynell
Candata Systems
