Re: query issue

Guido Konsolke wrote:

> jc,
>
> thanks for multiposting. Question answered in c.d.o.

That makes no sense ... c.d.o. has been deprecated and should not be used. So I'll answer it here.

OP wrote: "from my view I should only get the last record:" and "last has to be intended as inserting order"

Sorry curwen ... there is no such concept in relational databases. Your table is what is called a "heap" table meaning the data is stored is completely unordered.

The only way to get something out in the order in which it was inserted and/or updated is to supply the sort order while the record is being created or modified. That means YOU supply a sequence of some kind, numeric or date, that works with the ORDER BY clause.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)